Saya membuat sebuah stored procedure di sql server 2000 dengan tujuan menghitung jumlah waktu dan jumlah lemburan dari tabel lemburan dan hasilnya disimpan di tabel sementara tetapi saat saya mengeksekusinya melalui ASP tabel sementara tersebut tetap kosong. Mohon bantuannya.

Bahasa pemprograman di stored procedure sebagai berikut:
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[LemburHitRkpProc]
@NppK AS Char(5), @CabM AS Char(3), @DivM AS VarChar(30), @UnitM AS Char(3),
@GrpM AS TinyInt, @TglP1 AS Char(10), @TglP2 AS Char(10), @TtpM AS Bit, @CabI AS Char(3)
AS
BEGIN
DECLARE @JmX1 AS TinyInt, @JmX2 AS TinyInt, @JmX3 AS TinyInt, @LmbJmX1 AS Money,
@LmbJmX2 AS Money, @LmbJmX3 AS Money, @JamLmbX AS TinyInt, @LemburX AS Money,
@MakanX AS Money, @OngkosX AS Money, @BrutoX AS Money, @PphX AS Money,
@UngLmbX AS Money
SELECT @JmX1 = SUM(Jm1), @JmX2 = SUM(Jm2), @JmX3 = SUM(Jm3),
@LmbJmX1 = SUM(LmbJm1), @LmbJmX2 = SUM(LmbJm2), @LmbJmX3 = SUM(LmbJm3),
@JamLmbX = SUM(JamLmb), @LemburX = SUM(Lembur), @MakanX = SUM(Makan),
@OngkosX = SUM(Ongkos), @BrutoX = SUM(Bruto), @PphX = SUM(Pph), @UngLmbX = SUM(UngLmb)
FROM TabelLembur INNER JOIN TabelPegawai ON TabelLembur.Npp = TabelPegawai.Npp
WHERE TglLmb BETWEEN @TglP1 AND @TglP2 AND Ttp = @TtpM
AND Unit = @DivM AND Divisi = @UnitM AND TabelLembur.Npp = @NppK
GROUP BY TabelLembur.Npp, TabelLembur.Cab
INSERT INTO TabelLemburRekap (Npp, Jm1, Jm2, Jm3, JamLmb, LmbJm1, LmbJm2, LmbJm3,
Lembur, Makan, Ongkos, Bruto, Pph, UngLmb, Cab)
VALUES (@NppK, @JmX1, @JmX2, @JmX3, @JamLmbX, @LmbJmX1, @LmbJmX2, @LmbJmX3, @LemburX,
@MakanX, @OngkosX, @BrutoX, @PphX, @UngLmbX, @CabI)
END

Bahasa pemprograman di ASP untuk mengeksekusi sebagai berikut:
Dim LemWeb, RecLbRkp, TxtSql
LemWeb.Execute(“DELETE FROM TabelLemburRekap”)
Set RecLbRkp = Server.CreateObject(“ADODB.Recordset”)
TxtSql = “EXEC dbo.LemburHitRkpProc @NppK = '“