I would like to know how to concatenate two different values from two different columns from a SQL table using TSQL ?
As you can see, I would like to concatenate those two different columns X e Y, resulting in the follow column table:
Which query should be used here ?
You can use
SELECT Source, QtyPrevious, QtyToday, ProductPrevious, ProductToday, AvaDatePr, AvaDateToday, Clusters, CONCAT(X, '', Y) as Z from your_table_name;