Bravo Jeff  +1

This is the same guy who says he's pretty good at SQL.  I think I'm going to disagree.  If you can't normalize tables, how can you be 'pretty good'?

DECLARE @ndate nvarchar(50) = N'2010/03/15 01'
SET @Ndate = @ndate + ':00:00'
SELECT CONVERT(datetime, @ndate, 101)

As a C# developer I would say that I could write a routine like this in short order.  I will also add that it would be a huge mistake on...

Would the MERGE statement be of value here?  There is a good article here: 
https://www.mssqltips.com/sqlservertip/5373/sql-server-merge-statement-usage-and-examples/

Take a look at the article by Phil Factor posted today - 

How about something like this?

SELECT column1, column2, column3, ...
INTO db.schema.newtable 
FROM oldtable
WHERE condition;

Thank you for your respnses