Re: Dates Result Set

From: Steve Kass (skass_at_drew.edu)
Date: 04/21/04

  • Next message: Hugo Kornelis: "Re: => Trigger to split Trailer Loads" 
    Date: Wed, 21 Apr 2004 18:36:50 -0400

    Here is one solution:

    select cast(convert(char(8),getdate(),112) as datetime) + i as d
    from (
      select 0 as i union all select 1 union all select 2 union all select 3
      union all select 4 union all select 5 union all select 6
    ) T

    Steve Kass
    Drew University

    tom sawyer wrote:

    >Hi, All,
    >
    >I need a single result set that just returns today's date
    >plus 6 more days. I want to do this without a cursor.
    >Any ideas?
    >
    >Thanks!
    >T
    >
    >

  • Next message: Hugo Kornelis: "Re: => Trigger to split Trailer Loads"

    Relevant Pages