Home Forums SQL Server 2005 SQL Server 2005 Compact Edition select 21/(datediff(dd,getdate(),getdate()) RE: select 21/(datediff(dd,getdate(),getdate())

  • November 26, 2008 at 3:57 am

    #903620

    HI Just see below...............

    select 21/ case when datediff(dd,getdate(),getdate()) <1 then 1 else datediff(dd,getdate(),getdate()) end