Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: periods of dates

    Thank you David!

    June 29, 2005 at 8:37 am

    #569350

  • RE: periods of dates

    thanks, but what is "calendar table with the date range" ?

    June 29, 2005 at 1:08 am

    #569218

  • RE: periods of dates

    1.for this period

    DECLARE @fromdate datetime, @until datetime

    SET @fromdate = '2005-07-01'

    SET @until = '2005-07-08'

    output should be 'Occupied'

    2.for this period

    DECLARE @fromdate datetime, @until datetime

    SET @fromdate =...

    June 28, 2005 at 9:04 am

    #568961

Viewing 3 posts - 1 through 3 (of 3 total)