I also attempted to reproduce the problem on SQL 2000 but was unable too.

When I run your code it returns "qwertyuiuoipthe" as expected. 

Sorry that I couldn't be more helpful. ...

I believe that if you do not specify a length after a varchar it will default to 30.  So, as Vladan stated above, make sure you specify the length of...

Well, I just had this long reply I did.  But, for some reason it did not post the first time . So, this will...

Thanks for the reply Scott.  I forgot to mention that it worked in QA and SQL 2005 tools.  Unfortunately, my company has not switched to 2005 yet. 

I love your last...

I don't really know what my best job would be?  I have done many things already and I guess I'm still trying to find my niche.  I have been a...

You may need to verify that your client tools are also up to date with the service packs.  This is problem I had experienced but was corrected when I updated my...

I have had this same problem when I was attempting to use the debugger.  I found that it is necessary to have the updated service packs to match your server...

Hi Joe,

Is this Joe Celko the author?  Or are you just using his name for the forums?  Either way I appreciate your response to my issue.

I would like to explain...

Thank you Ray.  You hit the nail on the head.  I had forgotten to complete the evaluation portion of the AND clause on the join.  The CHARINDEX() was returning an...

Steve Rosenbach,

Thank you so much for the helpful information.  I never knew about the CTRL-TAB switching windows in QA or that CTRL + ; inserts the current date in a...

P. Barbin - I appreciate the link to SQL Assist but I don't write my DB code (stored procedures) in Visual Studio.  I use SQL QA.  This is where I...

I have been tempted to check this out for some time.   I am still considering it and will probably test it out after this review.

I have a question about the...

Hi Jeff,

Sorry I didn't respond sooner.  I have been swamped here and wasn't able to  check the boards sooner. 

I came up with my own solution and was just about to post...

Well unfortunately that depends on the question. It can have at least 1 to x.  In this instance x can be the number of possible responses per question. 

The original...

I'm not sure if this will help you but I have had many problems trying to get the debugger work.  And I just decided to test my debugger again to...