Viewing 15 posts - 46,816 through 46,830 (of 59,062 total)
Same thing, though... use MAX instead of SUM...
December 2, 2008 at 6:17 pm
That'll work... just be advised that it does contain a "partitioned" triangular join and if there're a large number of Pr_ID's for each agent, there will be a big time...
December 2, 2008 at 6:12 pm
Yep... that'll work, too! Haven't tested it for performance, though.
December 2, 2008 at 6:07 pm
1) Would I need to do a union all necessarily? Is it just considered good housekeeping to do it or does it serve a distinct purpose within this statement?
Heh... First,...
December 2, 2008 at 6:06 pm
I know lot's of good folks that like it, but I don't care for Oracle much, either. Many will disagree with me, but I find it too limiting.
December 2, 2008 at 5:57 pm
jeffkretz (12/2/2008)
Gaby Abed (12/2/2008)[hr
Agreed...I'm working on my MCTS for SQL 2005 but I plan to emphasize my experience first on the resumes and keep the certification at the end, probably...
December 2, 2008 at 2:04 pm
Heh... sorry... just over a year late on this one...
Leap year calculations don't need to be complex in SQL Server...
ISDATE(STR(@Year,4)+'0229')
December 2, 2008 at 11:30 am
Thought I'd revisit this one... calculation for Leap Years can be a lot more simple...
ISDATE(STR(@Year,4)+'0229')
December 2, 2008 at 11:23 am
... or a nice article on SSC, Phil. 😉
December 2, 2008 at 5:24 am
vijinarav (12/1/2008)
December 1, 2008 at 11:38 pm
Ninja's_RGR'us (12/1/2008)
Steve Jones - Editor (12/1/2008)
Heh... thanks for the vote of confidence, but I learn something new about T-SQL everyday even if it's how to NOT do something. 😀
I'd bet...
December 1, 2008 at 11:27 pm
You can simulate an indexed view... just make a preaggregated table as suggested before.
December 1, 2008 at 10:15 pm
puneet shadija (12/1/2008)
since we have many threads, which may concurrently try to insert a record to this table, thus I have used this lock to prevent this from happening
You just...
December 1, 2008 at 8:54 pm
As previously posted, WAITFOR DELAY will get you to the nearest 3 milliseconds. If you want microseconds, just to a couple of PRINT statements.
December 1, 2008 at 8:40 pm
That's exactly what SQL Server 2008 is... the ultimate service pack for 2005 😉
December 1, 2008 at 8:38 pm
Viewing 15 posts - 46,816 through 46,830 (of 59,062 total)