-- old code -- IF (@LastCaseEnds = NULL) BEGIN -- replace with IF (@LastCaseEnds IS NULL) BEGIN>I have this stored procedure. What it is basicly trying to do is get a list of all blocks (meetings.isblock=1) and the date to be released (meetings.endtime-meetings.releasedays), and the Highest date/time that belongs to that block (meetings.blockmember=1 and blockid=meetings.blockid).
>meeting BT ET OrigBlkSt OrigBlkEnd >------------------------------------------------------------------ >11364 04/09/2002 09:00 04/09/2002 12:00 NULL NULL >11366 04/09/2002 09:00 04/09/2002 12:00 NULL NULL > >* Abbrivated field names >>