MMartin1 (12/17/2015)

---

Banbo Bird (12/14/2015)

---

Hi,how can I get result like this:

Create table T1

(

pid INT primary key identity(1,1),

name varchar(10),

amount int

)

Create table T2

(

sid INT primary key identity(1,1),

subnum int,

flag varchar(5),

...

I want to Print all the records to a XML Page,So I Need to convert select result to variable

when c0=1 and a0=b0 then print

when c0=1 and c1=1 and a0=b0 and a1=b1 then print

when c1=1 and a1=b1 then print

when c1=1 and c2=1 and a1=b1 and a2=b2 then print

....

when...