Perhaps splitting it up might help

DELETE FROM fact.WorkOrder

WHERE WOStatus NOT IN ('C', 'X');

DELETE FROM fact.WorkOrder

WHERE CreateDate >= @startdate;

DELETE FROM fact.WorkOrder

WHERE CloseDate >= @startdate;

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]