Viewing 15 posts - 45,196 through 45,210 (of 59,063 total)
This is SQL Server 2005... with that in mind, you don't need the overhead of UDF's and you sure as heck don't need a cursor or While loop for such...
February 11, 2009 at 7:25 pm
It seems to happen every February... company finally gets a new budget for the year, hires some folks in January, and they start asking questions in February. It's compounded...
February 11, 2009 at 6:12 am
Thank you, Anirban. You're always gracious and kind with your words.
They republish this article about every two months or so to try and help folks with their...
February 11, 2009 at 6:05 am
viduvs (2/10/2009)
Thanks for all the replies.Actually this is one time activity. So we don't want to pay much attention towards optimization of this stored procedure.
Like Gail said, that's probably why...
February 10, 2009 at 10:54 pm
kbatta (2/9/2009)
February 10, 2009 at 7:01 am
In that case, this might be just a little faster because it doesn't have as many CONVERT's...
SELECT CONVERT(CHAR(11),GETDATE(),101)
+ CONVERT(CHAR( 5),GETDATE(),114)
February 9, 2009 at 10:07 pm
Bruce W Cassidy (2/9/2009)
February 9, 2009 at 5:36 pm
No... when you use any function on the column, the best that will happen is an INDEX SCAN which can actually be worse than a table scan if every row...
February 9, 2009 at 5:33 pm
What is it that you really want to do? Do you just want to return a list of items that can't be converted to an INT or do you...
February 9, 2009 at 5:30 pm
Olga B (2/9/2009)
I suspect it's because thinking through the problem is not the norm. 😉
BWAA-HAA!!! That's the perfect answer! Thanks for the feedback, Olga! 😀
February 9, 2009 at 12:10 pm
Garadin (2/8/2009)
Is it good practice then to add all criteria to the derived tables instead of the outer query? Guess that makes more sense overall anyways.
I hate to use...
February 9, 2009 at 10:52 am
andrewd.smith (2/8/2009)
OP does state the following which Jeff's query doesn't do.
I also want to...
February 9, 2009 at 10:46 am
Viewing 15 posts - 45,196 through 45,210 (of 59,063 total)