[Solved] How to concatenate two different values from two different columns with comma ” , ” using TSQL?

by


You can use concat as

SELECT 
    Source, QtyPrevious, QtyToday, ProductPrevious, ProductToday, 
    AvaDatePr, AvaDateToday, Clusters, CONCAT(X, '', Y) as Z 
from your_table_name;

solved How to concatenate two different values from two different columns with comma ” , ” using TSQL?