It occurred to me that I may be making this too hard...

Since the final target exists at run time, and it has the same schema as the query,...

Hi John, thanks for your perseverance, much appreciated.  I've attached the error.txt from yesterday.  Sorry about that.

However, I think I need to step back a bit, and ask...

I've made a bit of progress on this today, but am still having problems.

To recap, what I need to do is:
1) I have a particular query, that...

Hi John,

Thanks for your reply.  Re: SQL injection, I'm trying to isolate the post to the problem at hand, and not bog down the forum with code not...

Thanks all...

When I posted about VARCHAR(2) vs. CHAR(2), I meant it to just be an illustrative example.  I was hoping to wrap my head about VARCHAR vs. CHAR...

My actual question is resolved, but for completeness...

I will create the below SP:

ALTER PROCEDURE sp_DropTable (@tableName VARCHAR(255))
AS
BEGIN
  DECLARE @sql...

Again, thanks for the replies, much appreciated.

Ok, I found a link that helped my understanding:  https://www.mssqltips.com/sqlservertip/2981/using-parameters-for-sql-server-queries-and-stored-procedures/

@thom-2 A:

The documentation you've linked...

Thanks for the replies.  I appreciate the workarounds to the shortcomings in SSDT, and its failure to comply with its own documentation.

What you're trying to do there...

From the paucity of replies, perhaps the original question belonged in a data warehousing forum rather than here.

In my actual application, I've got an application layer (SAS) conducting...

This sort of works for #1, but I'm not sure it's best practice.  It's moving some of my application logic into the database layer - I'm not sure if that's...