Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT wo_id, description, date_added, date_scheduled, date_completed, GETDATE() AS Today, DATEDIFF(dd, GETDATE(), date_scheduled) AS Past_Due
- FROM dbo.imtbl_work_order
- WHERE (DATEDIFF(dd, GETDATE(), date_scheduled) <= 0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement