Skip to Content
0
Former Member
Feb 18, 2009 at 06:43 PM

SQ01 results in a single row

43 Views

Hi Gurus,

I have been using the sq01 query to do complex calculations and have been successful in creating tons of queries. What I am stuck with right now is this situation. I created a query and the result is in multiple rows. Here's what it looks like

Col1 Col2 Col3 Col4 Col5

0014 0.00 12.00 0.00 1.00

0014 20080428 0.00 0.00 0.00

0014 0.00 0.00 5.00 0.00

0014 0.00 0.00 0.00 0.00

Here;s what I want it to look like

Col1 Col2 Col3 Col4 Col5

0014 20080428 12.00 5.00 1.00

Which means i dont want any rows that basically have 0.00 throught and for the key 0014 I want all the data on one single row.

Is there anyway we can do it using sq01.

Any suggestions will be appreciated. Thanks in advance

Kavita

Edited by: Kavita on Feb 18, 2009 7:44 PM