In the Data tab, I modified the code as:

CREATE PROC Name (@MonthNum int, @Year int)

AS

DECLARE @query_head nvarchar(1000), @query_foot nvarchar(100), @sql_string nvarchar(1500)

SET @query_head = 'SELECT * FROM [dbo].[E.AN.ONDMD_EC_Leadership~~03~'

SET @query_foot =...

Maya - again thanks for your input and everyone else who posted. I hope you will be around once I try this and may again need more input. ...

Thanks for the comments Robert and Maya-

Maya - I will look into it. I guess the only issue I see is that we upload these files into our...