Viewing 15 posts - 31 through 45 (of 164 total)
Thanks Jagan for a very 'to the point' writeup. Special thanks to Rich for the valuable inputs.
Maz
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
July 3, 2009 at 9:38 am
ta.bu.shi.da.yu (7/2/2009)
Mazharuddin Ehsan (7/2/2009)
See some more useful comparisons in the below links:Be careful - some of the comparisons are not entirely accurate!
The context here is to understand...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
July 2, 2009 at 2:06 pm
richj (7/2/2009)
richj (7/2/2009)
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
July 2, 2009 at 2:05 pm
Filipe Miranda (7/2/2009)
I may not be remembering this correctly, but is it correct that schemas also differ between Oracle and SQL Server as the schema is unique to the instance...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
July 2, 2009 at 1:49 pm
David B (7/2/2009)
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
July 2, 2009 at 8:02 am
Hi jcrawf02,
You have a very valuable suggestion to modify the solution. The solution should sum the duration from your downtime table between the two points of time and subtract it...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
April 28, 2009 at 12:02 pm
Hi Megan,
I just came across your work while browsing the site. Got curious and checked it randomly. Could you please explain the below results it is giving. How may working...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
April 28, 2009 at 11:51 am
Sez,
You need to develop a function which will take three parametrs to give out the number of days between two days and use it in your query. For example,
SELECT...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
March 3, 2009 at 9:30 am
Hi Sez,
The solution willl be different if you are using Oracle. The solution "calculating work days"[/url] is meant for SQL Server.
Sincerely,
Maz
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
March 3, 2009 at 3:17 am
j (2/4/2009)
Mazharuddin Ehsan (2/4/2009)
Hi J Gravelle,Congrats for the high response to the write-up and making the topic a hit.
You're very kind. Shukriya.
I am anxiously waiting for the second part...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
February 5, 2009 at 5:36 am
Hi J Gravelle,
Congrats for the high response to the write-up and making the topic a hit.
I can foresee a demand for this modification/enhancement, since many SLAs are now written against...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
February 4, 2009 at 11:59 am
First you should define your requirement then work on finding a way how to do it in SQL Server. Just trying to find the equvalent of a feature in SQL...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 18, 2008 at 5:33 am
You can try the indexed views feature of SQL server introduced in SQL Server 2000
SQL Server 2000 Unveils Another Path to Peak Performance
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 17, 2008 at 2:56 pm
rshafer (12/3/2008)
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 11, 2008 at 4:32 pm
Chris (12/10/2008)
today the output of the sp would be
column names
source,type,10/12,09/12,08/12,07/12,06/12,05/12
tommorow it would be
column names
source,type,11/12,10/12,09/12,08/12,07/12,06/12
after which i move this output data into a table...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 11, 2008 at 4:02 pm
Viewing 15 posts - 31 through 45 (of 164 total)