TraciShultz
asked on
Can you create Static variables within SP ?
I am trying to write a SP that will return me the next first record but I need to have a static variabel to seed my sp.
Any Ideas would vbe greatly apprecieated.
my SP is a s follows : I would like FirstCount to be static
CREATE PROCEDURE DestRackTest @TubeOrder int
AS
declare @ret_val nvarchar(50),
@rackIndex Int,
@FirstCount int
SET @rackIndex =@Tubeorder % 96
IF @rackIndex = 1 AND @FirstCount > 0
BEGIN
SET @FirstCount = @FirstCount + 1
SET @ret_val = (SELECT Top 1 dbo.FinalDestRack .RackInfoID from dbo.FinalDestRack)
DELETE FROM FinalDestRack where dbo.FinalDestRack.RackInfo ID = @ret_val
SELECT Top 1 dbo.FinalDestRack.RackInfo ID
FROM dbo.FinalDestRack
END
ELSE
BEGIN
SELECT Top 1 dbo.FinalDestRack.RackInfo ID
FROM dbo.FinalDestRack
END
GO
Any Ideas would vbe greatly apprecieated.
my SP is a s follows : I would like FirstCount to be static
CREATE PROCEDURE DestRackTest @TubeOrder int
AS
declare @ret_val nvarchar(50),
@rackIndex Int,
@FirstCount int
SET @rackIndex =@Tubeorder % 96
IF @rackIndex = 1 AND @FirstCount > 0
BEGIN
SET @FirstCount = @FirstCount + 1
SET @ret_val = (SELECT Top 1 dbo.FinalDestRack .RackInfoID from dbo.FinalDestRack)
DELETE FROM FinalDestRack where dbo.FinalDestRack.RackInfo
SELECT Top 1 dbo.FinalDestRack.RackInfo
FROM dbo.FinalDestRack
END
ELSE
BEGIN
SELECT Top 1 dbo.FinalDestRack.RackInfo
FROM dbo.FinalDestRack
END
GO
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or use the registry, of course.