Row_number()

[niloofar norouzi]

سلام
لطف می کنید بفرمایید sp زیر چه مشکلی داره که اجرا نمی شه؟



create proc spS004GetTransactionDay
@StartRowIndex int,
@MaximumRows int
as
begin
SET NOCOUNT ON
select tS002ShareTransactions.[BoorsCode] ,tS002ShareHolders.ShareHolderID ,Row_Number() Over(Order By tS002ShareTransactions.[TransactionID]) As RowNum from tS002ShareTransactions
join tS002ShareHolders on tS002ShareTransactions.[BoorsCodeNo]=tS002ShareHolders.[BoorsCodeNo]
Where RowNum Between @StartRowIndex And (@StartRowIndex + @MaximumRows)
end

error:
Invalid column name 'RowNum

[behrouzlo]

دستورات را به شکل زیر تغییر دهید:


select BoorsCode ,ShareHolderID,RowNum From (
select tS002ShareTransactions.[BoorsCode] ,tS002ShareHolders.ShareHolderID ,Row_Number() Over(Order By tS002ShareTransactions.[TransactionID]) As RowNum
from tS002ShareTransactions
join tS002ShareHolders on tS002ShareTransactions.[BoorsCodeNo]=tS002ShareHolders.[BoorsCodeNo]
) As TblTemp
Where RowNum Between @StartRowIndex And (@StartRowIndex + @MaximumRows)