Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Record number as query result?

Author  Topic 

mikezat
Starting Member

11 Posts

Posted - 2001-05-11 : 19:58:50
Is there a way to get a recordset that contains 2 fields: 1) regular field and
2) record number .
example:
RecNum Item
1 item1
2 item2

etc


I've done it in Oracle,
but can not find it in SQL 2000.

Any help is greatly appreciated

   

- Advertisement -