Row_Number OVER RRN

Last Post 20 Apr 2006 05:11 AM by Shafiq. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

20 Apr 2006 05:11 AM

Is is possible to just get the Row_Number without specifying the OVER clause? My problem is that I have an excel file Linked in SQL server as Linked Server.

I want to know the actual excel row number if there is any problem with that particular row so that I can inform user about the error for that row number.

My data in excel file may not be sorted. So that's why I can not USE OVER caluse.

Please guide how to achive this.


Acceptable Use Policy