I like my ASUS ROG laptop.  I don't play many games on it, but that isn't the primary reason I bought it.  I wanted the power so I could easily...

Sometimes you have to wonder about people writing SQL code and this is just one example.  I am currently working through some code here at work that simply confirms that...

Set up a sandbox with the tables and data involved and try them both.  Be sure to include test data that will result in null data for the start/end datetime...

Check this out: https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql

You will notice you have the OUTPUT clause in the wrong location in your UPDATE statement.  If there are other issues, not enough information...