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)
 num row

Author  Topic 

wided
Posting Yak Master

218 Posts

Posted - 2010-06-21 : 10:09:48

hi, can you help me,

i use SQL2000
i want to select some records with the number of records

select Numrow, col1, col2...
from mytable

numrow is not a colonn

i want to have the result

1 col1 col2
2 col1 col2

thanks


webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-21 : 10:17:26
At least in SQL Server 2000 it is much better to do it in your front end if possible.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -