🚀 go-pugleaf

You can do this using Transact, however it is not very elegent.

Try creating 2 views:

Create View View1 as Select * from Table where Col2 = 1
Create View View2 as Select * from Table where Col2 = 2

And the select from the views:

Select View1.Col1, Sum(View1.Col3), Sum(View2.Col3)
From View1, View2
Where View1.Col1 *= View2.Col1
group by View1.Col1

Geoff Baxter
Telecom Australia
(03) 684-5438.
GBaxter@VACCNORQ.Telecom.com.au
 ----------
From: MSSQL-L
To: Multiple recipients of list MSSQL-L
Subject: Building SQL Query???
Date: Monday, 3 April 1995 3:26PM

        Pardon me for sounding like a newbie here, but I am really stuck
with trying to write a SQL statement (listed below).  I am trying to do
this in C++ currently to go against a MSSQL Server so I am stuck (as far
as I know with Transact).  If someone has other suggestions as to another
product that would give me additional ability with my SQL statements, I
would be more than all ears..as it were.  Many TIAs for anyone that could
help or provide guidance on this.

================

        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
===============================

John Murray
jmurray@dnasunnet.dna.mci.com