Thursday, October 18, 2007

Replace NULL numbers to -1 sample SQL

isnull(WO.Production_Order_Id,-1) IsWOCreated


//

SELECT PO.Id,DueDate,isnull(WO.Production_Order_Id,-1) IsWOCreated
FROM ProductionOrder PO left outer join dbo.WorkOrder WO
on PO.Id =WO.Production_Order_Id

No comments: