If they are new columns and your existing data will not be filled with valid data, then I would opt for creating a new table.  If for your existing data...

I would rather see some fields have a NULL value rather than spaces or -1.  This allows me to use ISNULL or COALESCE to assign a different field or value. ...

Have you tried to change the SQL to do an INNER join on your table dbo.tbl_termcode?  I would think that would be faster than in the WHERE clause.

Not sure what you are trying to accomplish here.  If you are trying to compare a date on the table to be < 

June 21, 2018 at 2:27 pm

#1994917

My concern is the environment, what affect this will have on sea life?  Let's quit using the oceans as a dumping ground.  I know there is no visible waist, but...

I was of the same thought as Steve and Jeff.  But recently I've started using the MERGE statement, so far "knock on wood" I haven't ran into any issues.

Is this what you are after?  
SELECT ID, name, createdDate
FROM @sample
UNION ALL
SELECT NULL, NULL, NULL

Under the 'Topics' there is a column in the view for 'Last Post'.  It would be nice if that column was on the 'Replies' view.  This would...