Sample output from Print Statements:

Profile for ETLMappingID: 597

JOIN SQL1 Len: 141

JOIN SQL2 Len: 151

PreparedStatement Len: 3862

JOIN STATEMENTS CREATED IN...

Hi guys.

Here is how the variables are being DECLARED * Denotes the variables in question here

,@PreparedStatementIDas int

,@PreparedStatement as varchar(8000) ...

In morning i can get to it. But count on the following

Set @preparedStatement = @preparedStatement + ' ' + @sql1 + '...

No nvarchar anywhere for sure. Hardly ever use, like never. And aware cuts length in half. Paste code in morning. Need permission as I'm a...

Checking by doing len like you suggested and simply copy paste in SSMS. Either way same result

Get back 4k. Sorry, yes tried that. Destination physical field is varchar 8000. Actual expected field len about 4200

Great, thank you. I will check it out!

Good grief! Thank you!!!

I actually just wrote this differently and have it working and deployed but I will keep this handy as well; thank you so much.

I found something I...

Here is code that works like intended. (EXCEPT it does not insert the results into a table)

When you run this you get a table of results back in ssms. I...

I have read, and read about the output clause prior to posting here.

Clearly I am at a bit of a loss because I have yet to get this working; that...

The script is working except I can not insert into a table the results that are returned.

I THOUGHT I figured it out with another script.

Can someone please lend a hand on this one? Perhaps just throw the insert into my script so I can see a...

I have an insert into at the top and this is where I am grabbing the source data and placing into derived table. Then I need the results into a...

No I put this together for purposes of the post; my bad.

My actual code is the following:

(I have a string with a , as a deliminator. I need to...

No I put this together for purposes of the post; my bad.

My actual code is the following:

(I have a string with a , as a deliminator. I need to...