Return Record Number with query

[CoolRiyaz]

I want to return record number with my query output.

I dont' want to use IDENTITY function and temp table for this purpose as I am dealing with very huge data.


any suggestions...




Riyaz

[Taftheman]

I want to return record number with my query output.

I dont' want to use IDENTITY function and temp table for this purpose as I am dealing with very huge data.


any suggestions...




Riyaz

Hi can you explain a bit more please

[CoolRiyaz]

Hi can you explain a bit more please

Suppose my query is :

SELECT FirstName, LastName, Address FROM EmpMaster

I want the output like :

SrNo FirstName LastName Address
1 asas dfddsf dfdsf
2 dsfdsfdsf dfdsfdsf dfdfsdf
3 .... and so on


I dont want to use temp table and IDENTITY function as data is very very huge.

Any other solution?


Riyaz

[iburyak]

IF you use Server 2005.

Try this:

[PHP]select row_number() over (order by ID) as NumberItems, *
from table_name[/PHP]

[CoolRiyaz]

IF you use Server 2005.

Try this:

[PHP]select row_number() over (order by ID) as NumberItems, *
from table_name[/PHP]

Hi
sorry,
I am using SQL Server 2000

Now tell me what to do.


Thanks

[iburyak]

You can't get away without temp table on Server 2000.
If you want this solution let me know.


Thank you.

[CoolRiyaz]

You can't get away without temp table on Server 2000.
If you want this solution let me know.


Thank you.

I am already having this solution but now its performance issue on huge data.

Thanks for your inputs


Riyaz