Update Multiple tables with Single Stored Procs

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE  [dbo].[receipts_UpdateReceiptDetails]
	(
		@ReceiptID			INT,
		@SomeNewValue		INT
	)

AS

SET NOCOUNT ON

/*
__________________________________________________________________________________________
Author:			Dylan Morley
Description:		

Created:		
Modification History:	Date		Modified By	Modification
			[dd/mm/yy]	[Name]		[Desc]

__________________________________________________________________________________________
*/

BEGIN TRY
	BEGIN TRANSACTION

	UPDATE
		TBLA
	SET
		WhateverColumn = @SomeNewValue
	Where
		ReceiptNo = @ReceiptID
	
	UPDATE 
		TBLC
	SET
		WhateverColumn = B.Adjamt
	FROM
		TBLC
	JOIN
		(
			SELECT 
				Invno, Adjamt
			FROM	
				tblb 
			Where
				ReceiptNo = @ReceiptID		
		)
	AS 
		B
	ON
		TBLC.Invno = B.InvNo

	COMMIT
	
END TRY
BEGIN CATCH

  IF @@TRANCOUNT > 0
     ROLLBACK

  -- Raise an error with the details of the exception
  DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int
  SELECT @ErrMsg = ERROR_MESSAGE(),
         @ErrSeverity = ERROR_SEVERITY()

  RAISERROR(@ErrMsg, @ErrSeverity, 1)


END CATCH

-- Return any error codes \ Reset the NOCOUNT property.
RETURN @@ERROR
SET NOCOUNT OFF