asked on

I need help with SQL syntax

Hi experts,
Please let me know if the SQL syntax below is correct (in SQL Server 2008)? Thanks in advance:

BEGIN TRY
	BEGIN TRANSACTION [TRAN1]
		CASE WHEN @OrderNumberCustomer LIKE 'DS-KM%' OR @OrderNumberCustomer LIKE 'DS-SE%' 
		THEN
			INSERT INTO [INFORPROD].[GPInterface].[WH1].ShippingPackage(OrderNumberCustomer,TrackingNumber,ShippingCost)
			VALUES(@OrderNumberCustomer, @TrackingNumber, 0)
		ELSE
			INSERT INTO [INFORPROD].[GPInterface].[WH1].ShippingPackage(OrderNumberCustomer,TrackingNumber,ShippingCost)
			VALUES(@OrderNumberCustomer, @TrackingNumber, @ShippingCost)							
		END
	COMMIT TRANSACTION [TRAN1]
END TRY

Open in new window

Mike Eghtebas

BEGIN TRY
	BEGIN TRANSACTION 
		IF <your logic> 
                   BEGIN
			INSERT INTO [INFORPROD].[GPInterface].[WH1].ShippingPackage(OrderNumberCustomer,TrackingNumber,ShippingCost)
			VALUES(@OrderNumberCustomer, @TrackingNumber, 0)
                    END
		ELSE
                     BEGIN
			   INSERT INTO [INFORPROD].[GPInterface].[WH1].ShippingPackage(OrderNumberCustomer,TrackingNumber,ShippingCost)
			   VALUES(@OrderNumberCustomer, @TrackingNumber, @ShippingCost)							
		     END
	COMMIT TRANSACTION 
END TRY
BEGIN CATCH
       ROLLBACK TRANSACTION 
END CATCH

Open in new window

It is not quite clear what your logic is at: IF <your logic>

ASKER CERTIFIED SOLUTION