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.