What is the error you are getting?

I * think* you are saying you only want vmainmembers to return if they do not exist in the firstprincardfooter for the same year on that vmainmember record. If so,...


Declare @StartDate Date = '12/1/2018'
      , @EndDate Date = '12/31/2018'

Then replace your dates in your code with the variables.

There may be a better approach to this out there but this works and can at least give you a base to start with. 

Create Table...

DECLARE @SQLString nvarchar(255)

SET @SQLString = 'SELECT * FROM vSalesInvoices WHERE (Order_Status = 0 OR Order_Status = 4 OR Order_Status = 5) AND Delivery_Date= ''' +...

@CustID is set to an INT, needs go be cast to a character to work.  Change to Cast(@CustID as Varchar). Should work then. Definitely look up sp_executesql and the benefits...