go to tools then options in there in the query options you can see what the character limit is 🙂

thanks guys i did try that already but still cant find the post i want 🙁 had a bit of code in it i wanted never mind thanks yous anyway...

It al depends on what your changing these values to, are your changes to the first 3 characters going to be the same for every row? if so then perhaps...

I take it thats a no then :w00t: any moderators????

If you only want the numerical value of said column then you could drop the character like for example.

providing the alphabetical character is the first character you could do somehting...

@michael-2 Valentine Jones "max char 8192" this may be the case for SQL2000 but its not for SQL2012 wich i was using. I also used profiler trace...

i had the same issue with varchar(max) when using it to create dynamic SQL, when executing my SP i relieved syntax errors, i run the SP with select (@SQL) and...

can you provide some DDL please sample data etc

the reason you get duplicates is because of your joins are returning courtesan product, can you just explain how you want your results 🙂

arrr ok well i could only answer in what you put perhaps you can add some DDL to this thread representative data and what you expect the output to be,...

Aye agreed

@sean Lange

It all depends on the task in hand, so in answer to this thread i gave some example SQL to help with his question, up to the...

ahh sorry i misunderstood what you where trying to achieve

i always use nolock 🙂

Thanks Gila, not noticed that it wokred on size just noticed last tiem i restarted SQL server the report was empty