sql server - SQL query show the first if they flag -


i have query sql , thats works good. want contact information 2 persons

i use query:

select      contact = stuff((select ';' + ltrim(rtrim(ad.[name])) + ', ' + ba.[ib] + ', ', ba.[bi] + ', ', ba.[bn]                      ba                       join ad on ba.adid = ad.adid                      ad.adnu = '448412' or ad.adnu = '5444877'                      xml path(''), type).value('.', 'nvarchar(max)'), 1, 1, '') 

they want! want edit query, because persons have 2 adresses , in table "ba" column thats name "isadress".

these column have 0 false , 1 true. want list show @ first position adress 1 in column "isadress", don't know how change where. how query !?

maybe where other select statement chek adress true?

please me.

greetz

select contact = stuff(( select ';' + ltrim(rtrim(ad.[name])) + ', ' + ba.[ib] + ', ', ba.[bi] + ', ', ba.[bn] ba join ad  on ba.adid = ad.adid (ad.adnu = '448412' or ad.adnu = '5444877') order ba.isadress desc xml path(''), type).value('.', 'nvarchar(max)'), 1, 1, '') 

Comments