Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sql Stored Procedures

    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
    Last edited by macman; 04-30-2009 at 05:10 AM.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •