select empid from emp
where datepart(dd,GETDATE()) != 1
and datepart(dd,getdate()) !=
DATEADD(dd,-day(dateadd(mm,1,getdate())), dateadd(mm,1,getdate()))
select DATEADD(dd,-day(dateadd(mm,1,getdate())), dateadd(mm,1,getdate()))
select dateadd(mm,1,getdate())
where datepart(dd,GETDATE()) != 1
and datepart(dd,getdate()) !=
DATEADD(dd,-day(dateadd(mm,1,getdate())), dateadd(mm,1,getdate()))
select DATEADD(dd,-day(dateadd(mm,1,getdate())), dateadd(mm,1,getdate()))
select dateadd(mm,1,getdate())
No comments:
Post a Comment