DECLARE @Location INT,
		@taskJ INT,
		@@ProjectID INT,
		@@ErrorCode INT				

CREATE TABLE #Errortasks (LocationID INT, taskJ INT)

SELECT DISTINCT s.Location, s.CPPS_task-- ,j.SiteId,j.JobID
INTO #NewGPMtasks
  FROM Orders s (NOLOCK)
 WHERE  s.Location > 0

--BEGIN TRANSACTION

DECLARE Cur_taskJ2 CURSOR FOR 
Select Location, taskj
FROM #NewGPMtasks 

--Open cursor
OPEN Cur_taskJ2
FETCH NEXT FROM Cur_taskJ2 INTO @Location, @taskJ

WHILE @@FETCH_STATUS = 0
BEGIN	

	IF EXISTS (SELECT Product FROM Products WHERE SiteID = @Location and Tasks = @taskJ)
	BEGIN
	
	BEGIN TRANSACTION

		UPDATE LocationChart
		SET Numeric1 = Numeric1 + 1
		WHERE Location = 1
			AND Control = 40 
			
		SET @@ErrorCode = @@Error

		IF @@ErrorCode <> 0 
		GOTO OnExit
		
	--Insert a new Step
		INSERT INTO OrderSteps
			   (Location, Details, Tasks, CDate)
		 VALUES(@Location, '', @taskJ, getdate()) 

			SET @@ErrorCode = @@Error

			IF @@ErrorCode <> 0 
			GOTO OnExit			
			
	COMMIT TRANSACTION	
END
ELSE
BEGIN
	BEGIN TRANSACTION

	INSERT INTO LocationMaster
		   (Location, Description, CDate)
	 VALUES(@Location, '', getdate()) 


	SET @@ErrorCode = @@Error

	IF @@ErrorCode <> 0 
	GOTO OnExit			

 	 INSERT INTO OrderSteps
		   (Location, Details, Tasks, CDate)
	 VALUES(@Location, '', @taskJ, getdate()) 

	SET @@ErrorCode = @@Error

	IF @@ErrorCode <> 0 
	GOTO OnExit			

	COMMIT TRANSACTION	
		
	END

FETCH NEXT FROM Cur_taskJ2 INTO @Location, @taskJ
	
END

CLOSE Cur_taskJ2
DEALLOCATE Cur_taskJ2

OnExit:
	ROLLBACK TRANSACTION
	INSERT INTO #Errortasks VALUES (@Location, @taskJ)
		
CLOSE Cur_taskJ2
DEALLOCATE Cur_taskJ2