User Profile

Collapse

Profile Sidebar

Collapse
DanBWeb
DanBWeb
Last Activity: Mar 27 '08, 04:30 PM
Joined: Sep 13 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • DanBWeb
    started a topic Between & Dates
    in SQL Server

    Between & Dates

    I am trying to query SQL, based on a date

    For each term I have a record in the "TermDate" table:

    TemName StartDate EndDate
    Term 1 9/1/2007 11/21/2007
    Term 2 11/22/2007 1/29/2008
    Term 3 ... ...

    Seems easy enough, but I can't get it to pull the appropriate record. if xDate = 9/20/2007, the query should return me Term 1, for example.

    Both date fields are...
    See more | Go to post
    • DanBWeb
      replied to Determining if a time falls within a given set of time intervals.
      in Javascript
      "All you have to do then is run a couple of binary searches through periods until you find the first element in periods where periods[i].time <= login and the first element in periods where periods[i].time >= logout."

      Can you give an example?

      Thanks,

      Dan B
      See more | Go to post

        Leave a comment:

      • DanBWeb
        started a topic Determining if a time falls within a given set of time intervals.
        in Javascript

        Determining if a time falls within a given set of time intervals.

        Hi (using javascript) -

        I have a schedule divided into periods
        Period 1: 8:00 am - 9:10
        Period 2: 9:15 am - 10:00 am
        Period 3: 10:15 am - 11:05 am
        ...
        ...
        ...
        Remember your days in school?..:)

        I have a login time and a logout time (login at 8:10 am and logout at 9:45 am)

        I need to know
        1.) what period they logged in,
        2.) what period they...
        See more | Go to post
        • DanBWeb
          replied to Stored Procedure Vs UDF
          in SQL Server
          How do you return the vales in a UDF vs a SP?
          See more | Go to post

            Leave a comment:

          • DanBWeb
            started a topic Stored Procedure Vs UDF
            in SQL Server

            Stored Procedure Vs UDF

            Hello -

            SQl newcomer here. I have an application that looks for scheduling conflicts (example: college student's class schedule.

            Basically I have a record set that looks like this:

            Student Section M1 M2 M3 M4 M5 M6
            ----------------------------------------------------------------------
            1 2 T1 W3 F5

            What I want to do is loop through...
            See more | Go to post
            No activity results to display
            Show More
            Working...