Now those are nice questions .

I strongly suggest you read this :

The Curse and Blessings of Dynamic SQL

How much does it grow to on the dev server after the job has run?

HTH.

Why are you using dynamic sql for this???

What transformations do you need to do to that data?

How about you use 1 view.

Then select all fields from that view, then select all fields but 2-3 from that same view???

Also make sure that the execution plans don't change...

can we some some before/after picture??

What's the solution??

So you're querying from 2 different tables???

HTH.

I know... wanted to increase the post count by one more .

It's often easier when you see the picture with some fresh eyes .

So which one did you actually need??

Can you post the link of the chanllenging query??