Viewing 15 posts - 50,851 through 50,865 (of 59,078 total)
shamshudheen (4/2/2008)
Jeffthe query you posted is throwing error "Operand type clash: INT is incompatible with DATETIME "
Then, you're done something wrong... Int IS compatabible with DATETIME in SQL...
April 30, 2008 at 6:52 pm
Heh... yeah... You're right and I agree... except I don't allow garbage names into the server. :hehe:
April 30, 2008 at 6:38 pm
Thanks, Steve... I'll take a look. One test is worth a thousand guesses...
I still like the ultimate power saver... turn it off when you're not using it. Not...
April 30, 2008 at 9:18 am
Thanks guys... I sure do appreciate your feedback.
I just got word that it's coming out on May the 7th.
April 30, 2008 at 9:15 am
See the following URL... almost identical situation...
http://www.sqlservercentral.com/Forums/Topic491969-149-1.aspx#bm492576
April 30, 2008 at 9:10 am
Mahesh Bote (4/30/2008)
... and, just to be sure, you can do INSERTs, UPDATEs, and DELETEs on Table Variables in a UDF... just not on external tables.
Jeff, I was talking about...
April 30, 2008 at 9:08 am
Yeah... I agree... if it's a return to the GUI, the comma separated list would probably be the way to go for the very reasons you stated. Thanks...
April 30, 2008 at 9:07 am
Steve Jones - Editor (4/30/2008)
On LCDs, all colors require energy, so Blackle doesn't really help, especially over time. It was...
April 30, 2008 at 9:04 am
Adrian Nichols (4/30/2008)
Jeff,Here's a link to Googles Earth Hour effort....
http://www.google.co.uk/intl/en_uk/earthhour/
And this one's for the official blog saying that it may actually use more energy!
http://googleblog.blogspot.com/2007/08/is-black-new-green.html
Thanks, Adrian!
April 30, 2008 at 9:00 am
Casting to an INT should actually run a bit faster over a large number of rows.
April 30, 2008 at 8:55 am
While you're at it... check to see what other traces you have running. Too many or the wrong kind of trace will also slow the world to a crawl.
April 30, 2008 at 8:54 am
The code I posted work without error on my end. If you are typing, are you sure that your typing a zero and not an "OH"?
You know the rules......
April 30, 2008 at 8:53 am
Bruna (4/30/2008)
I dont know, Its dynamic...Could be 3-4-5-6... 🙁
Putts (4/30/2008)
April 30, 2008 at 8:38 am
Matt Miller (4/30/2008)
I was being funny last night - just remember the "math" version and the "stats" version actually give you different results (based on their different definitions)....
Not a problem......
April 30, 2008 at 8:05 am
Viewing 15 posts - 50,851 through 50,865 (of 59,078 total)