Sql Server 2000 progressive index or row number select query
Mar 7th, 2008 by Onyrix 832 Views | 
Email This Post
| 
Print This Post
(5 votes, average: 4.2 out of 5)
Loading ...SET NOCOUNT ON
CREATE TABLE #RowNumber (
RowNumber int IDENTITY (1, 1),
emp_id char(9) )
INSERT #RowNumber (emp_id)
SELECT emp_id
FROM employee
WHERE job_id = 10
ORDER BY lname
SELECT RowNumber, e.emp_id, lname, fname, job_id
FROM #RowNumber r JOIN employee e
ON r.emp_id = e.emp_id
ORDER BY RowNumber
DROP TABLE #RowNumber
SET NOCOUNT OFF
del.icio.us
Digg
Furl
Reddit
Technorati
Stumbleupon