I have a Table named PersonalLedgerForTheiftFundAndShareClone I want to get The Sum Of TInterest ( TheiftFundInterest ) within The Date Range Of 2014-03-31 00:00:00.000 To 2015-03-31 00:00:00.000 For each Employee and Then Update The TInterest with The Sum Where Date is 2015-03-31 00:00:00.000 For that Specific Employee.
I Have Written a Stored Procedure To accomplish This Task But Not Able To Get The Desired Result.
CREATE PROCEDURE UpdateTheiftFundInterest
AS
DECLARE @var1 VARCHAR(50), @var3 CURSOR, @var4 INT
SET @var1 = 0;
SET @var3 = CURSOR FOR
SELECT EmNo FROM [WBSEB].[dbo].[PersonalLedgerForTFundAndShareClone]
OPEN @var3
FETCH NEXT
FROM @var3 INTO @var1
WHILE @@FETCH_STATUS = 0
BEGIN
SET @var4 = 0;
SELECT @var4=SUM(TInterest)
FROM [WBSEB].[dbo].[PersonalLedgerForTFundAndShareClone]
WHERE TDate >= '2014-03-31 00:00:00.000' AND TDate <= '2015-03-31 00:00:00.000'
AND EmNo = @var1
UPDATE [WBSEB].[dbo].[PersonalLedgerForTFundAndShareClone]
SET TInterest = @var4
Where TDate = '2015-03-31 00:00:00.000' AND EmNo = @var1
FETCH NEXT
FROM @var3 INTO @var1
END
CLOSE @var3
DEALLOCATE @var3
GO
Can Anyone Tell me What I am Doing Wrong ?
