Viewing 15 posts - 52,486 through 52,500 (of 59,070 total)
Hassie (2/17/2008)
Thanks alot - this did the job
You bet... Thanks for the feedback.
Just remember...if the count of rows for each group starts to grow, the performance will suffer greatly very...
February 17, 2008 at 8:32 am
Peso (2/17/2008)
Msg 208, Level 16, State 1, Line 1Invalid object name 'New.AddAnnex'.
Doh!... Thanks for the correction, Peter... that's what I get for late night posting. I'll correct that post...
February 17, 2008 at 8:24 am
Yes, I absolutely agree... any type of formatting should be done only in the GUI... if there is one...
But the keyword in the title of the thread is "Show"......
February 17, 2008 at 8:21 am
C'mon... I know you're in a pinch but stop and think about it... we don't know what your SalesDetails detail table looks like, we know nothing about the data in...
February 17, 2008 at 7:59 am
Oh... be careful, now... IsNumeric cannot be equated to IsAllDigits. IsNumeric will allow currency symbols, $, comma, decimal point, spaces, tabs, and a host of other individual characters. ...
February 16, 2008 at 11:10 pm
This was a pretty interesting question with no responses and I have no idea of what the answer might be... anyone got any idea on this, at all?
February 16, 2008 at 10:34 pm
... and when it comes to % of batch, it can still lie!
February 16, 2008 at 10:06 pm
EDIT:
I originally (incorrectly :blush: ) suggested do something like this... but, as Peso pointed out below, it's going to throw an error if table doesn't actually exist. My appologies...
February 16, 2008 at 10:02 pm
OP has "left the building"... 😛
February 16, 2008 at 9:51 pm
Heh... dang... thanks Kevin! I should'a looked in BOL...
February 16, 2008 at 9:49 pm
Matt Miller (2/15/2008)
February 16, 2008 at 11:38 am
J (2/15/2008)
Mr. Moden,I just set the options of the query analyzer as you suggested. Thanks a million for both:
1. a very useful suggestion
2. not laughing at my dumb error.
Regards
Thanks for...
February 16, 2008 at 11:36 am
Matt Miller (2/15/2008)
There's the obvious way, emulating a SQL-style cursor, which seems oh so very obvious. ...
February 16, 2008 at 11:27 am
Frank,
Heh... understood on things possibly changing...
It's a bit funny... for years, people jumped on me for using the occasional undocumented feature (xp_DirTree to be specific) because "Microsoft could...
February 16, 2008 at 11:17 am
TheSQLGuru (2/15/2008)
Kevin, do you, by any chance, have a Microsoft article...
February 16, 2008 at 11:03 am
Viewing 15 posts - 52,486 through 52,500 (of 59,070 total)