I'm new to TSQL and need help please -
I have to Calculate a field value as Position Duration = (Work Order End Date - Work Order Start Date)/30. Round up to the next whole number.
in the DB the 2 dates are of the format-
Work Order End Date =2013-05-31 00:00:00.000
Work Order Start Date = 2012-12-03 00:00:00.000