Hi I have a SQL statement in VFP which I am to convert to SQL Server SPT

SELECT localcursor.*, RECNO() AS record FROM localcursor INTO CURSOR localcursor

previously I have already created a temptable for this localcursor's original fields (the ones that are being *ed in this statement).

In short I have a temptable in SQL Server, now I have to add this RECNO() equiv. field in the temptable.

Is there any way to go about it.