SET@startDate='2007-01-01 00:00:00' SET@officeId=NULL SET@invoicedStatus=0 WHERE ejh.EnquiryDeleted =0 AND (@startDateISNULLOR ejh.DateTimeTaken >=@startDate ) AND (@officeIdISNULLOR cp.OfficeId =@officeId) AND (@invoicedStatus=0ORCASEWHEN t.InvoiceNo ISNOTNULLTHEN1ELSE2END=@invoicedStatus)