I have the following query...
SELECT StartDate, EndDate, FROM table
I am trying to figure out how to add the following to the query,
if EndDate is NULL then replace the NULL with Todays Date
Also I want to create a new column I also want to create a new column that tells me the number of days between StartDate and EndDate.
I am brand new to SQL and just starting out writing TSQL statements. Thank you very much for the help.