i can't figured it out so, here i am providing my trigger as well store procedure.
this is my trigger which is on table dbo.wrk
-
create trigger trigger_qcheck
-
on [dbo].[Q_CHECK_WORK]
-
for insert
-
as
-
exec [dbo].[SDFD_CheckAndLoad]
-
once records gets into dbo.wrk this trigger fires up and moves data to dbo.glass by executing store procedure and here is the store procedure:
-
CREATE PROCEDURE SDFD_CheckAndLoad
-
-
AS
-
-
BEGIN
-
-
DECLARE @Id varchar(19)
-
-
DECLARE @CBComplete varchar(1)
-
-
DECLARE @PalmName varchar(20)
-
-
DECLARE c5 CURSOR FOR
-
-
SELECT [ID], CB_COMPLET, PALMNAME FROM dbo.Q_CHECK_WORK
-
-
WHERE [ID] NOT IN (SELECT [ID] FROM dbo.Q_CHECK_GLASS)
-
-
OPEN c5
-
-
FETCH c5 INTO @Id, @CBComplete, @PalmName
-
-
-
-
print @id
-
-
print @CBComplete
-
-
print @PalmName
-
-
WHILE @@FETCH_STATUS = 0
-
-
BEGIN
-
-
PRINT 'INSIDE WHILE'
-
-
IF @CBComplete='T'
-
-
BEGIN
-
-
PRINT 'COMPARE'
-
-
INSERT dbo.Q_CHECK_GLASS SELECT * FROM dbo.Q_CHECK_WORK WHERE [ID]=@Id
-
-
/*delete from dbo.Q_CHECK_WORK WHERE [ID]=@Id*/
-
-
PRINT 'AFTER INSERT'
-
-
END
-
-
ELSE
-
-
INSERT dbo.Q_CHECK_FILTER values(@Id, @PalmName)
-
-
-
-
-
-
FETCH NEXT FROM c5 INTO @Id, @CBComplete, @PalmName
-
-
END
-
-
CLOSE c5
-
-
DEALLOCATE c5
-
-
END
-
-
GO
-
-
Please help on solving this problem.
Thank You,
