Record Number

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

select IDENTITY(int, 1,1) AS RecNum, * INTO #NewTable from yourtable

select * from #NewTable

maijoe SSC Enthusiast Points: 140 More actions · Answer 2

Thanks very much.

However, it does not return correct record# position as my query return.

Ex. My query's result set like this:

1.A

2.B

3.d

4.f

when I used your statement, my result set become

4.a

3.b

2.f

1.d

How can I work around this, I really want the record# will show correct as my result set above. I'm in dark now.

Minh Vu

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

would an

ORDER BY RecNum

help?

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 4

Some other options for doing what you want can be found my article posted here:

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp

Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

maijoe SSC Enthusiast Points: 140 More actions · Answer 5

SSC Enthusiast

Points: 140

December 17, 2003 at 1:07 pm

not at all.

maijoe SSC Enthusiast Points: 140 More actions · Answer 6

I am very appreciate all of your help, special thank to Greg Larson. Reading your article helps me solve the problem. Again, my deepest gratitude.

Minh Vu