CREATE PROCEDURE UpdateProduct 
	@ProductID int, 
	@BrandName varchar(255), 
	@ProductName varchar(255), 
	@SRP decimal(10,2), 
	@GrossWeight decimal(10,2), 
	@NetWeight decimal(10,2), 
	@ShelfWidth decimal(10,2), 
	@ShelfHeight decimal(10,2), 
	@ShelfDepth decimal(10,2), 
	@LastUpdated binary(8) AS
	DECLARE
		@RowCount int
	BEGIN
		SET @RowCount = 0
		UPDATE Products
		SET BrandName = @BrandName,
			ProductName = @ProductName,
			SRP = @SRP,
			GrossWeight = @GrossWeight,
			NetWeight = @NetWeight,
			ShelfWidth = @ShelfWidth,
			ShelfHeight = @ShelfHeight,
			ShelfDepth = @ShelfDepth
		WHERE ProductID = @ProductID
		AND LastUpdated = @LastUpdated
		SET @RowCount = @@RowCount
		SELECT @RowCount AS "RowCount"	
	END
GO