Home Forums SQL Server 2008 T-SQL (SS2K8) What would be right approach? RE: What would be right approach?

  • September 2, 2012 at 10:28 pm

    #1532812

    May be that:

    SELECTDATEADD (DAY,sv.Number,'20120801')

    FROMmaster.dbo.spt_values sv

    WHEREsv.Name IS NULL AND sv.Number < 31