Thanks Chris, that did the trick!!

Thank you so much everyone!

Once the stored procedure is created, how do you call it?  

USE [hp_accting]
GO
/****** Object: StoredProcedure [dbo].[PROCPartnerTaxAllocation]  Script Date: 4/26/2017 1:14:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC...