Getting the number of a row from a flat file source in SQL
How might I get the number of a row from a flat file source with a script component in SQL?
Answer Question
| Jul 15 2008 6:42 PM GMT
| asked by
SQL Server Ask the Experts
SQL, ROW_NUMBER, Scripts
row_number in sql 2000
how to find out the row_number in sql 2000 like using row_number() function in sql 2005
View Answer
| May 8 2008 10:51 PM GMT
| asked by
Rl
ROW_NUMBER, SQL Query, SQL Server 2000
ROW_NUMBER in SQLServer
In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there's a separate count for each deptno in this example:)SELECT deptno, ename, ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS...
View Answer
| Jan 11 2008 11:15 PM GMT
| asked by
FrankKulash
SQL Server, ROW_NUMBER, SQL
