Friday, 15 May 2015

SQL Server: combine two small Selects in one -



SQL Server: combine two small Selects in one -

i using next nested selects part of larger query.

is there way can combine both of them in 1 don't have run 2 separate queries here ?

// ... r.requester, ( select a.email requesteremail logtable a.ntid = r.requester xml path(''), elements, type ), r.approver, ( select b.email approveremail logtable b b.ntid = r.approver xml path(''), elements, type ), // ...

many help this, tim.

select a.email requesteremail,b.email approveremail logtable b bring together logtable on b.ntid = r.approver , a.ntid = r.requester xml path(''), elements, type

sql sql-server select stored-procedures

No comments:

Post a Comment