Andrew-495157 (9/7/2012)
Description_reference contains 2 rows with the value August 2012........ ???
Now look at the original code:
WHERE Job_Bag.Description_Reference = @OrderID -- SQL was trying to conver August 2012 to an integer for this comparision.