Hello
have a good day
is there any way to retrieve record number with each record in simple sql qry?
e.g
select "REC_no",name from "table_name"
the result should display like this
1 ,noman
2,imran
3,Jose
etc
take care
thanking u in advance
Bye
noman78 0 Light Poster
noman78 0 Light Poster
Hello there
i myself find the answer
here it is , if u are also looking for it
http://www.sqlservercentral.com/columnists/mcoles/sequentialordering.asp
in SQLserver2000 there is no direct way, but SQL2005 come up with solution
take care
bye
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.