...

View Full Version : Sql Stored Procedures



macman
04-30-2009, 05:08 AM
Hi ,

I have a quary for taking the training course and the number of runs for that
course. I wanted to take the 'Number of days' and 'In Which Month'
this course is taught on. the table will look similar to the prototype below


Course Code - Run_Number - Start Date - End Date

101 1 01/01/2009 01/01/2009
101 2 02/01/2009 02/01/2009
101 2 03/01/2009 03/01/2009
101 3 04/01/2009 04/01/2009
102 1 31/01/2009 31/01/2009
102 2 01/02/2009 01/02/2009
102 2 02/02/2009 02/02/2009

how to count the number of days like the below

Course = 102
Count of Run Number = 2
No of Days = 1 day in january and 2 days in February

Thanking you inadvance

macman



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum