oh, then you and John are both saying that if varchar datatype size is much bigger than actual length of data, this will not affect query performance or indexing.

John says No, Eddie gives a fully explained Yes (on referenced link).

Because of the well reasoned explanation I accept Eddie's answer. 

Large datatypes require more space to...

thanks for the help, guys.  Cursor is working and I've incorporated sql_modules.  Final result below. 
Is there a better way to do this that doesn't involve creating an object...

Thanks frederico_fonseca.    I made the correction.

When running I am getting error   Msg 102, Level 15, State 1, Line 10 Incorrect syntax near 'dbo'. ...

I've adopted all suggestions for my query statement except for sys.sql_modules.definition since I need to see how to join to that instead of sys.comments.  Right now just trying to get...

It is still a working functionality ie. it returns top 1000 rows?  Sorry, I ask.   I am facing an tech support group that will not fix this broken functionality...

You're right.   I just wasn't seeing it.

In this dataset if I want the subquery and outerquery to return results I need to join on YYYYMM  instead of...

Sergiy, where did I complain about a lack of answers?  

I marked the post as solved, i then had an issue with it and posted a followup.  Anyone who...

it was false hope of someone furthering the post.  That's my perspective. Hope it has value to you.

isn't that what private messages are for?  

I had additional questions which I posted after marking Phil's great answer (by the way) as the answer.

When i...

sorry you took it so badly.  But seriously, Ed, if I didn't get Phil's answer the first time, why would your reposting it help?

while you two were having a little secret code language conversation I was pulling my hair out with parameter passing to exec sql task. Man alive.