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

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

Hi Thanks for your reply..

my requirement is,

select 21/datediff(dd,getdate(),getdate())

if I execuite above i will get an error as Msg 8134, Level 16, State 1, Line 1

Divide by zero error encountered.

but I...