I know we have some language barriers here but keep in mind that nobody can do anything with the code you loaded. You have an update to a temp table...

Your string really is still in the variable you just can't see it. You can check the length of it with

select datalength(@sqlstring)

Here is an example of what Michael was talking...

There is a limit in the output of a query in SSMS. Just because you can't see it doesn't mean it is not in your variable. Tools -> Options ->...

Don't get too hung up on it. Joe is a really smart guy but he admits his online personality is intentionally arrogant. He hits that nail on the head with...

YUCK!!!! After you catch your breath for beating your dev senseless....you will have to convert each of your columns. Assuming they are in the same format you can just add...

To get some real help you need to help us help you. Please see the link in my signature for best practices on posting questions. There are lots of people...

So slap your developer and make him change it to an appropriate datatype. 😛

This of course is exactly why you should use datetime datatypes to hold datetime data. Assuming your format is consistent you can use something like the following;

declare @val varchar(20) =...

steve.anderson 7639 (6/28/2011)

I have this query (below). MaterialDesc is the fieldname, and I want to append data to the value. I'm certain I have not selected the value...

That and the total lack of proof. The author just says do this instead of that because it is faster but presents no facts to back up the claims. Jeff...

Would you mind sharing so others might learn?

Surely with almost 900 points you should know how NOT to post a question. There are no details for anybody else to go on. We can't see over your shoulder...

This is a...

The hard part here is that nested cursors are hideously horrible for performance. This doesn't look like you need a single cursor let alone two of them. There are few...

I'm guessing you didn't actually read the article I pointed you to. If you post some ddl, sample data (insert statements) and desired output with a clear explanation you will...