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
Post a Comment