C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Getting Row Number from a Table in SQL-2000

Posted Date: 15 Jan 2008 Resource Type: Code Snippets Category: SQL

Posted By: Nisanth Vijay Member Level: Bronze
Rating:

Points: 10

This code is used to get Row Number from a Table in SQL-2000.


	SET NOCOUNT ON

CREATE TABLE #RowNumber (
RowNumber int IDENTITY (1, 1),
PKDailyStockID char(9) )

INSERT #RowNumber (PKDailyStockID)
SELECT PKDailyStockID
FROM prdstk001m00
WHERE PKDailyStockID <100

SELECT RowNumber, e.*
FROM #RowNumber r JOIN prdstk001m00 e
ON r.PKDailyStockID = e.PKDailyStockID

DROP TABLE #RowNumber

SET NOCOUNT OFF

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to get the first day of the week, last day of the week and last day of the month using T-SQL dat
	Previous Resource: Table types in SQL Server
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

web conferencing