Viewing 15 posts - 27,061 through 27,075 (of 59,102 total)
Erin's code is pretty much the way that I'd do it. For an explanation of how it works, please see the following (my very first) article.
http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/
Erin used the numerical...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2013 at 10:36 am
Spot on, Lynn. Thanks for the cover. Busy 20 hour day at work yesterday.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2013 at 10:28 am
Sean Lange (4/5/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 6:20 pm
opc.three (4/8/2013)
Jeff Moden (4/8/2013)
opc.three (4/8/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 4:31 pm
Well done on posting readily consumable data and a good description of the problem. I suspect that, unlike what my article says on the subject of posting readily consumable...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 4:29 pm
j.miner (4/8/2013)
I would not use a pivot since that is used to turn row values into column aggregations such as sums.
It will also turn row values into column values using...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 4:24 pm
Heh... Craig, you must've beat by post by seconds. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 4:20 pm
There are many so-called "set-based" solutions for Running Totals. One of the most common can be found in the following article which explains why it shouldn't be used.
http://www.sqlservercentral.com/articles/T-SQL/61539/
Other than...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 4:19 pm
greg.bull (2/22/2012)
I'm trying to break down events by hour of day as 00-23.
So if an event has a duration of 5 hours, from 22-03 then (this is the question)...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 3:58 pm
Heh... there are no shades of gray. Either the code is fast or slow. Whether you choose to work on it or not is a decision. 🙂
Anyway, I've...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 3:54 pm
MannySingh (4/8/2013)
Anyone..
Are you doing transaction log backups?
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 2:56 pm
opc.three (4/8/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 11:08 am
SwePeso (4/8/2013)
Jeff Moden (4/8/2013)
Thanks for stopping by, Peter. Haven't seen you around much and it's a real pleasure to see that fabulous mind at work here, again.
I've been trying...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 10:46 am
ALZDBA (4/8/2013)
Completely astonished by the simplicity of the solution.
Huge thank you for notifying and publishing...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 10:22 am
ChrisM@Work (4/8/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2013 at 10:15 am
Viewing 15 posts - 27,061 through 27,075 (of 59,102 total)