USE [Dev_SageReporting]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE  [dbo].[hgsp_backloglaborb_sync]

AS	
DECLARE @intErrorCode INT

BEGIN TRAN

INSERT  INTO BackLogLaborB
        SELECT  *
        FROM    BackLogLaborCurrent AS A
        WHERE   NOT EXISTS ( SELECT *
                             FROM   BackLogLaborB AS B
                             WHERE  A.PIT = B.PIT )

	SET NOCOUNT ON;

	SELECT  @intErrorCode = @@ERROR
IF ( @intErrorCode <> 0 ) 
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION