QPR - if you're talking # of rows, why don't you check @@ROWCOUNT - if > 1 then delimit, else return asis ?!?!

I come across the same problem everytime I try to search for something...

5000 posts - the reason mhite is aware of the # of page results is because it is...

that's right 5000 posts - almost 6000 posts...that's pretty impressive remi - I think you were neck-to-neck with frank only about 2 wks ago...that makes it about 600 posts in...

5000 posts - quelle est la différence entre..

Actually, it would be in your best interests to use only QA for some time

...

shashank - afaik, this is the third post you have with display problems in Enterprise Manager - as I explained earlier, EM picks up the regional settings and Query Analyzer...

Derek - don't know if you've gotten around to reading the articles yet or not but here's some help from the first one I listed:

divide your t-sql into 2 separate...

5000 posts - you are not a "bad communicator" at all...I think though, that Derek's problem is not with a specific datatype but that regardless of the error encountered, he...

5000 posts...Derek says that he's deliberately inserting wrong data to see if he can "force an error"...Derek - it would help to post the ddl and sample data...also, I don't...

That should stir things up for a few days... - Bryant - that's a veritable pandora's box right there...so I'm not going to fall into the completely useless trap of...

Derek - couple of things:

1) Not sure why you're converting @@error to string but it's not necessary.

2) capture the @@error in your variable immediately after your statement..

SET @intError = @@ERROR/PRINT...

I have tried to do without cursor like the suggestion in the first respond, but no luck...

Derek - could you please post the code that you used and the...

Here's an alternate suggestion - why don't you script the "create table"...export the data to a file (word, excel..etc.) - run the script on your target database and import the...

Also - you seem to be doing a lot of data type conversions - from varchar to decimal and datetime....please watch out for inaccurate data that might result from this!!!

Ideally...

shashank - I don't think I understood your first question - could you pl. rephrase ?!

As for the second - EM picks up your locale settings for Date & Time!!

Helen - don't know if you've had the chance to read some of the articles on this site on dts packages...here're links to a couple of them that may help...