Does the column allow for NULLs?  You could check for that and see if it is quicker...

No idea if this will work in DTS, but here is an option.

I know.  I just thought there was an error happening with this and thought that might be the location. 

Thanks

It is not well documented in BOL under sp_executesql.  Here is a snippet of code I used in conjunction with a #TempTable [#Variables] to send the OUTPUT into a @Variable [@Code]. ...

You do NOT want to do that!  That style of join “results in an ambiguous query that can be interpreted in more than one way.” (Microsoft SQL Server Books On...

THANK YOU ALL! 

This works great and now I can assign work for these big suckers! 

aaahhh..., no.  Well, er, yes... 

It is 4,000.  But I still get the error I have been posting, (along with the exact code I run) when I try and do this...

I will check further...

I saw that in BOL, but I must have been brain-dead thinking this was pulling in all the text within the SP into one long string...  Either way, I am...

Same #$% error!  I even tried altering your suggestion to see if dividing the length first would help, but not good...

SELECT SubSelect.[Name], SubSelect.TLength

FROM( SELECT so.[Name], SUM(( LEN( sc.[Text])...

  It's not mine...  [Wrong with it?  I can't type that much ]

I am working with many...

Not sure what it is you want to change about this query?  The direction of the joins? 

This might help:

A brief history of SQL

You also could try selecting into a new table by joining the tables of interest and scripting that new table? 

103.5   

(We're SQL Server 2000 - I should have been more specific - oh, dopey me...) 

What version of SQL Server are you on?  I cannot use alias's for GROUP BY or ORDER BY.  I still get the same length error... 

This is a bummer...  I'm...