USE [enes]
GO
/****** Object:  StoredProcedure [dbo].[SPWITHPARAMETER_AND_RETURN_VALUE]    Script Date: 05/26/2011 16:50:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPWITHPARAMETER_AND_RETURN_VALUE]
  (
    @EMPID INT,
    @RETURNVALUE INT =0
  )
  AS
    DECLARE @COUNT INT
    DECLARE @ADET INT
    DECLARE @KALAN INT
    DECLARE @i INT
  BEGIN
  SELECT @COUNT=COUNT(*) FROM tblEmployee
  SET @i=@EMPID;
 
    IF(@COUNT >0)
      BEGIN
              SET @KALAN=@COUNT%4;
              SET @ADET=@COUNT/4;
            SET @RETURNVALUE =@ADET*(@i-1)+@i;
            SELECT * FROM (
            SELECT
            ROW_NUMBER() OVER (ORDER BY EmpId ASC) AS rownumber,
            *
            FROM tblEmployee
            ) AS foo
            WHERE rownumber <= @RETURNVALUE+@ADET AND rownumber>=@RETURNVALUE
            END
 
  END
 
  EXEC SPWITHPARAMETER_AND_RETURN_VALUE 2,3

Bu makale 472 kere okundu.