USE [DC]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
  ALTER TRIGGER [dbo].[AlreadyPrintedmigrateData]
    ON [dbo].[AleadyPrinted]
    AFTER INSERT AS
    BEGIN
  --  SET NOCOUNT ON

    SELECT remark FROM INSERTED

INSERT INTO StoreTransfered
        (transNum, dat, qty, [description],upc,size,itemCode,storename,remark,datinserted)

    SELECT
        transNum, dat, qty, [description],upc,size,itemCode,storename,remark,datinserted
        FROM StoreTransfers
        where StoreTransfers.remark = remark


WAITFOR DELAY '00:00:05';

DELETE FROM [DC].[dbo].StoreTransfers where remark= remark
END