🚀 go-pugleaf

jtmurray@netcom.com (john murray) writes:

>	Using Transact SQL, I need to return a table like this:
>====================================
>FIELDA       FIELDB       FIELDC
>====================================
>B             100          150
>C             210          350
>D             145           0
>====================================

>	from a table similar to the one listed below.  This selects the 
>value of Col1 and provides the sum of Col3 into either FieldB or FieldC 
>based on the value of Col2 (i.e. if Col2 is 1 then the Sum of Col3 into 
>fieldB...etc..)

>Table...
>===============================
>Col1      Col2        Col3
>===============================
>B           1          100
>B           2          150
>C           1          210                           
>C           2          350
>D           1          145
>===============================
I keep a generic "rotate" table with values:
testval   flag_1    flag_2   flag_3...
1          1         0        0
2          0         1        0
3          0         0        1

and 
select col1,sum(flag_1*col3), sum(flag_2*col3)
from mytable,rotate
where col2=testval
group by col1
Bob Munson, 74451.1500@compuserve.com
>