CREATE PROCEDURE [dbo].[spInsertCustomer]
(
	@CustomerID char(10),
	@CustomerName varchar(50),
	@Address varchar(50),
	@City char(20),
	@ContactPerson varchar(50),
	@ParentID char(10),
	@Operator char(10),
	@Modifier timestamp OUTPUT,
	@Jan money,
	@Feb money,
	@Mar money,
	@Apr money,
	@Mei money,
	@Jun money,
	@Jul money,
	@Agt money,
	@Sep money,
	@Okt money,
	@Nov money,
	@Des money
)
AS
BEGIN 

	SET NOCOUNT ON
	
	DECLARE @Err1 int, @Err2 int	
	BEGIN TRANSACTION
	
		INSERT INTO Customer(CustomerID,CustomerName,Address,City,ContactPerson,ParentID,Operator)
		VALUES(@CustomerID,@CustomerName,@Address,@City,@ContactPerson,@ParentID,@Operator);
		
                          -- Set @@Error to variable if an error occure in second query
		SET @Err1 = @@ERROR
		
		INSERT INTO CustomerTarget(CustomerID,Jan,Feb,Mar,Apr,Mei,Jun,Jul,Agt,Sep,Okt,Nov,Des)
			VALUES(@CustomerID,@Jan,@Feb,@Mar,@Apr,@Mei,@Jun,@Jul,@Agt,@Sep,@Okt,@Nov,@Des);
                         
                          [B]-- Set @@Error to variable if an error occure in second query
		SET @Err2 = @@ERROR

		-- Check if an error when inserting data then doing ROLLBACK and if no error then COMMIT
		IF @Err1 = 0 AND @Err2 = 0
			BEGIN
				COMMIT TRANSACTION
				PRINT 'SUCCESS'
			END
		ELSE
			BEGIN
				ROLLBACK TRANSACTION
				
				SELECT @CustomerID = CustomerID,
					@Modifier = Modifier
				FROM Customer
				WHERE (CustomerID = @CustomerID);
				
				PRINT 'FAILED!' + LTRIM(STR(@@ERROR))
			END
END