Viewing 15 posts - 3,691 through 3,705 (of 9,715 total)
Abu Dina (2/14/2013)
Maybe this?
SELECT ordertotalFROM #MoneyTest
where ordertotal - round(ordertotal, 2) > 0
Oh. You want me to use the SIMPLE solution. 😀
<headdesk>
Really? I had to make things THAT difficult for myself?
Thanks,...
February 14, 2013 at 9:48 am
Why can't you just change your IF statement?
February 14, 2013 at 9:22 am
Grant Fritchey (2/14/2013)
Brandie Tarvin (2/14/2013)
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
February 14, 2013 at 5:04 am
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
February 14, 2013 at 4:39 am
Does Ask SSC require a different user login than SSC? I'm logged in here, but it won't let me post an answer to someone else's question without logging in again.
February 14, 2013 at 4:15 am
Jeff Moden (2/13/2013)
RBarryYoung (2/8/2013)
Ewww, Tom! I hesitate to ask what "squat thrusts" must mean over there. :sick:
BWAAAAAAAAA-HAAAAAAA-HAAAAAAA!!!!! (clutching my sides and just blew a half dozen Cheerios out my...
February 14, 2013 at 4:13 am
I'm going to SQL Saturday in Omaha, NE. But I'm afraid that and the Jax (and probably Orlando) events are the only SQL Server related events I'll be able to...
February 13, 2013 at 8:15 am
Grant Fritchey (2/13/2013)
I think we're back to the Roadhouse rule set here. Be nice.
And always keep a set of spare tires in the trunk.
February 13, 2013 at 4:54 am
Colin,
Forgive me, but I'm a little confused on the scenario. Am I reading this correctly that your schedules table is not a distinct record set but will always have duplicate...
February 12, 2013 at 9:26 am
Corgi,
I have since learned that if you kill the SPID (not the job), then the SPID will stop the job on its own and rollback. It may take a while,...
February 11, 2013 at 7:48 am
Apple accused of stealing Microsoft's secret DBCC Timewarp! See link for details!
http://www.geekculture.com/joyoftech/%5B/url%5D
and if you can't figure out what part of the comic I'm referring to, let me know.
February 11, 2013 at 5:30 am
Thank you for expounding, Paul. I learned something new this morning.
February 11, 2013 at 5:00 am
Roger,
If I understand things correctly, it isn't about equality of the Account Number match. It's about you asking the engine for more information than the nonclustered index could easily supply....
February 8, 2013 at 12:46 pm
Am I mistaken, Barry? On page 1 of this thread, Craig says he found the solution. Or did I misread that?
February 8, 2013 at 12:00 pm
Lynn Pettis (2/8/2013)
Roger Sabin (2/8/2013)
But I still don't see why the first index is more "correct" when it requires trolling through thousands of records to find...
February 8, 2013 at 11:34 am
Viewing 15 posts - 3,691 through 3,705 (of 9,715 total)