'Selecting values from two columns and concatenating them into a column on the same table within two date

I need to concatenate two columns into one, on the same table. But I need to do this for records that were added within a specific time period. I am thinking of doing something like:

BEGIN TRAN
    UPDATE dbo.TableName SET NewColumn = CONCAT(ISNULL(column1, ''), ' ', ISNULL(column2, ''))
COMMIT

I am running the query on MSSQL. I am not sure how to add the date constraint

sqlsql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions