Viewing 15 posts - 52,891 through 52,905 (of 59,064 total)
Adam Haines (1/10/2008)
I Found this workaround on this site. With this you can return a postive number of zero from a function.DECLARE @NBR INT
SET @NBR = -123456789
SELECT round(@NBR,-1-floor(log10(abs(@NBR))))
more info:
http://www.sqlservercentral.com/articles/Advanced+Querying/afixfunctionintsql/2487/
Adam......
January 15, 2008 at 5:52 am
You can also mail me on the below email address.
A bit selfish, there... no one but you would learn, then. 😉
My first reaction is "stupid people" really did it to...
January 15, 2008 at 5:40 am
If I could make a suggestion... I think auto-grow is a bit overrated... sure, in 2k5, they made it almost instantaneous... but auto-growth frequently means that the DBA hasn't planned...
January 15, 2008 at 5:27 am
Clever... effective... and vengeful... all in the same action... I LIKE IT! 😛
January 15, 2008 at 5:15 am
Hi Mark,
Thanks for the feedback.
On the posting of XML you mentioned... The best thing to do would be to simply attach the XML as a file...
January 15, 2008 at 5:11 am
Jeff Moden (1/14/2008)
Yes... use "Dynamic SQL" to accomplish this...
Ack... not enough coffee... sorry.
Gail's (GilaMonster) post is correct for this...
January 15, 2008 at 5:09 am
Chirag (1/15/2008)
between '2008/01/01 12:00:00:000 AM' and '2008/01/01 11:59:59:997 PM' if u want all records between the 2 dates.
Just a suggestion...
The optimizer is going to evaluate the BETWEEN code in...
January 15, 2008 at 5:03 am
Heh... I take the low road... disable all logins (except mine), answer the phone to see who's squawkin' 😉 (just kidding... in most cases 😛 )
Great article, David!
January 14, 2008 at 9:47 pm
suma (1/14/2008)
i tryed sys.all_object, sys.procedures but no luck.
Sorry, didn't see that... if you can't find it there, then I don't know where it might be, especially if you're logged in...
January 14, 2008 at 9:35 pm
Yes... use "Dynamic SQL" to accomplish this...
January 14, 2008 at 5:30 pm
Heh... "get out there and strike a blow for liberty."
... and we'll leave the lights on for ya!
January 14, 2008 at 5:18 pm
I'll just bet the phantom proc is stored in the Master database 😉
January 14, 2008 at 4:59 pm
You'll get a "Divide by Zero" error if the following ever resolves to zero... plan on it...
(Sum(CASE WHEN ISNULL([MailDate1], 0) = 0 THEN 0 ELSE 1 END))
January 14, 2008 at 4:57 pm
Ok... let's try this one more time and then I'm just going to ignore your posts in the future...
Read this, do this, or forget this...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 14, 2008 at 4:52 pm
Heh... Keep in mind that the BETWEEN examples are rarely correct because they don't allow all times of the day to be included or they mistakenly include dates with...
January 14, 2008 at 4:49 pm
Viewing 15 posts - 52,891 through 52,905 (of 59,064 total)