January 6, 2010 at 2:50 pm
I think I finally figured the problem out!
For some stupid reason I had @sql = @sql + @sql + @Variable in 8 places! (waaaaay towards the bottom)
I caught it after printing the results of @sql and pasting them into word and realized I saw the original select columns way down in the list again...I was like huh?
So yeah suffice to say Word said I have over 40k characters filled in. It works fine now...sorry for the confusion and thanks for the help!
Link to my blog http://notyelf.com/
January 6, 2010 at 3:21 pm
Ok I do have the code fixed now but I am still running into the problem towards the end of my code. I pasted into word and it says there are 9,593 characters with spaces and 8507 characters with no spaces (yes characters not words).
Is there a setting I need to adjust or another way I can do this? I have done just about all I can think of to get this to work.
Link to my blog http://notyelf.com/
January 6, 2010 at 6:32 pm
That is strange I am only returning some 6k+ characters and I still get a truncated (though very close to the end now) sql statement.
Is it possible because I am using a CTE within the sql statement that I am getting lesser characters returned?
Link to my blog http://notyelf.com/
January 7, 2010 at 1:17 am
shannonjk (1/6/2010)
That is strange I am only returning some 6k+ characters and I still get a truncated (though very close to the end now) sql statement.
That's possibly a management studio setting. Check in the Options menu.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply