Hi,

Yes, All null's are handled (using isnull), So no chance of Null.

No there is no case-expressions

Part of Stored Proc

--**---

insert into #tmpschedule select top 1000 sch_Id,sch_Cntid,sch_Emailid,sch_Groupid,sch_Userid,sch_type from tbl_Scheduleletter where sch_Senddate...

Hi,

Yes, All null's are handled (using isnull), So no chance of Null.

No there is no case-expressions

Part of Stored Proc

--**---

insert into #tmpschedule select top 1000 sch_Id,sch_Cntid,sch_Emailid,sch_Groupid,sch_Userid,sch_type from tbl_Scheduleletter where sch_Senddate <=...