Viewing 15 posts - 50,341 through 50,355 (of 59,078 total)
You need to define what a "week" is before anyone can help... Do weeks start on a Monday or ??? Are you talking about ISO week #'s or SQL...
May 22, 2008 at 4:10 pm
Wayne,
Take a look at the following URL and warp the technology to do exactly what you need...
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
It will be nasty fast... methods used will take care of a million rows...
May 21, 2008 at 10:59 pm
Not good... you can get dupes that way because of the relatively narrow INT range that CHECKSUM offers compared to the binary range of NEWID()... here's the proof of the...
May 21, 2008 at 10:50 pm
No problem. Thank you for the feedback.
Generally speaking, folks like to see running balances on their monthly reports. Take a peek at the following article for a super...
May 21, 2008 at 10:08 pm
wgarces,
See the following article... it covers this type of concatenation and a couple of related pitfalls to avoid...
May 21, 2008 at 9:41 pm
I don't believe that works the way the OP posted... that will only give 1 employee name per company.
May 21, 2008 at 9:40 pm
Yep... move the process to a data base that uses the SIMPLE recovery mode. If you don't have one... make one... call it "ScratchPad" or "SandBox" or something like...
May 21, 2008 at 9:32 pm
Why wouldn't the max ID for each BusKey contain the latest data? :hehe:
May 21, 2008 at 9:11 pm
First, the CONVERT on the datetime column will kill any chance of using an Index SEEK if the column is indexed. Second, you just need to add a simple...
May 21, 2008 at 8:30 pm
Way too generic a question... but here's some generic answers...
You need to make sure the correct indexes are in place and that the queries can actually use them effectively. ...
May 21, 2008 at 8:24 pm
Viewing 15 posts - 50,341 through 50,355 (of 59,078 total)