.

creating row number in sql select statement

The following sql query example will create row numbers on the fly:

SELECT  ROW_NUMBER() OVER (ORDER BY patient_id) , *
  FROM [Patient_Episodes]

What's your thoughts on this?

*

Protected by WP Anti Spam