Viewing 15 posts - 31 through 45 (of 163 total)
Thanks Jagan for a very 'to the point' writeup. Special thanks to Rich for the valuable inputs.
Maz
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...
July 2, 2009 at 2:06 pm
richj (7/2/2009)
richj (7/2/2009)
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...
July 2, 2009 at 1:49 pm
David B (7/2/2009)
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...
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...
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...
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
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...
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...
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...
December 18, 2008 at 5:33 am
You can try the indexed views feature of SQL server introduced in SQL Server 2000
December 17, 2008 at 2:56 pm
rshafer (12/3/2008)
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...
December 11, 2008 at 4:02 pm
Viewing 15 posts - 31 through 45 (of 163 total)