USE [Laserfiche_DB]
GO
/****** Object:  StoredProcedure [dbo].[spENRange2]    Script Date: 29/06/2016 17:03:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spENRange2]

@p0 Int,
@COMPANYNAME NVARCHAR(255),
@POLICYTYPE NVARCHAR(255),
@POLICYNO NVARCHAR(255),
@YEAR NVARCHAR(255)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @MyTempTableType as table
(
[SNo] [int] NULL,
	[Group_Company_Name] [nvarchar](255) NULL,
	[Group_Company_Dept ] [nvarchar](255) NULL,
	[Policy_Type] [nvarchar](255) NULL,
	[Policy_No] [nvarchar](255) NULL,
	[Year] [nvarchar](255) NULL,
	[Local_Currency] [nvarchar](255) NULL,
	[USD_Exch_Rate] [nvarchar](255) NULL,
	[Employee_No] [nvarchar](255) NULL,
	[Employee_Name] [nvarchar](255) NULL,
	[Gender] [nvarchar](255) NULL,
	[Designation] [nvarchar](255) NULL,
	[Status] [nvarchar](255) NULL,
	[Entry_Date] [date] NULL,
	[ProcessID] [nvarchar](255) NULL,
	[Comments] [nvarchar](3000) NULL
)
DECLARE @p1 Int = 20
Insert into @MyTempTableType
SELECT [t1].[SNo], [t1].[Group_Company_Name], [t1].[Group_Company_Dept ] AS [Group_Company_Dept], [t1].[Policy_Type], [t1].[Policy_No], [t1].[Year], [t1].[Local_Currency], [t1].[USD_Exch_Rate], [t1].[Employee_No], [t1].[Employee_Name], [t1].[Gender], [t1].[Designation], [t1].[Status], [t1].[Entry_Date], [t1].[ProcessID], [t1].[Comments]
FROM (
    SELECT ROW_NUMBER() OVER (ORDER BY [t0].[SNo], [t0].[Group_Company_Name], [t0].[Group_Company_Dept ], [t0].[Policy_Type], [t0].[Policy_No], [t0].[Year], [t0].[Local_Currency], [t0].[USD_Exch_Rate], [t0].[Employee_No], [t0].[Employee_Name], [t0].[Gender], [t0].[Designation], [t0].[Status], [t0].[Entry_Date], [t0].[ProcessID], [t0].[Comments]) AS [ROW_NUMBER], [t0].[SNo], [t0].[Group_Company_Name], [t0].[Group_Company_Dept ], [t0].[Policy_Type], [t0].[Policy_No], [t0].[Year], [t0].[Local_Currency], [t0].[USD_Exch_Rate], [t0].[Employee_No], [t0].[Employee_Name], [t0].[Gender], [t0].[Designation], [t0].[Status], [t0].[Entry_Date], [t0].[ProcessID], [t0].[Comments]
    FROM Laserfiche_TameenReports_Ext.dbo.Tbl_EB AS [t0] WHERE [t0].[Group_Company_Name] = @COMPANYNAME AND [t0].[Policy_Type] = @POLICYTYPE AND [t0].[Year] = @YEAR AND [t0].[Policy_No] = @POLICYNO
    ) AS [t1]
WHERE ([t1].[ROW_NUMBER] BETWEEN @p0 + 1 AND @p0 + @p1)

Select * from @MyTempTableType
ORDER BY [SNo] ASC
RETURN
END