How can i display the row numbers of the results of the below statements:
SUM(CASE WHEN ITED_TED_CODE ='BED' THEN ITED_NET_LC_AMT ELSE 0 END)AS BED,
SUM(CASE WHEN ITED_TED_CODE ='EDU CESS' THEN ITED_NET_LC_AMT ELSE 0 END) AS EDUCESS,
SUM(CASE WHEN ITED_TED_CODE ='SHECESS' THEN ITED_NET_LC_AMT ELSE 0 END) AS SHECESS,
SUM(CASE WHEN ITED_TED_CODE ='BED CT3' THEN ITED_NET_LC_AMT ELSE 0 END) AS BEDCT3,
SUM(CASE WHEN ITED_TED_CODE ='EDU CESS CT3' THEN ITED_NET_LC_AMT ELSE 0 END) AS EDUCT3,
SUM(CASE WHEN ITED_TED_CODE ='SHECESS CT3' THEN ITED_NET_LC_AMT ELSE 0 END) AS SHECT3,*/


Yogesh

__________________
Yogesh

What do you want as row number?? there is no row number in a database (at least not in a modern one)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Gonzalo,

Your information is out of date.

Microsoft SQL Server 2005 now has a ROW_NUMBER ranking function that can be used with result sets.

Rand E. Gerald



Rand

wow.. sorry about that them...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Of course, if Yogeshyl is using some other database or an earlier version of SQL Server, my reply is meaningless.

BTW: I had to look it up in the SQL Server 2005 manual. That is a new feature that I haven't had a chance to use yet. We are in the process of converting our databases from SQL Server 2000 to SQL Server 2005.

Rand

He is using ORACLE, since he is also using the DECODE function.

See his other post.

The original question doesn't really make any sense, though, no matter how you look at it.

First of all, "the below statements" are *NOT* statements; they are simply individual fields in a *SINGLE* record.

So *IF* this was SQL Server 2005, he migh do

SELECT ROW_NUMBER, SUM(...) AS BED, SUM(...) AS EDUCESS, ...

But then he would have only *ONE* row (number 1) unless he has other things in the query that create other rows (and he does).

But in any case, *each* of those SUM( )s would *NOT* have its own row number.

So I, for one, don't understand the point of the question, at all.