I do not have ADD or DELETE or ALTER permission in my instance of SQL Server. I have a temp table in which I want to add a column to.
This new column is a concatenation of other columns and I want to write it to another temp table.
Right now, when I employ the CONCAT code below, the output is just that one column. I want to have the CONCAT column along with all the other columns in my original temp table (#df_ERA4_b).
How can I achieve this?
You are almost there. The reason you end up with only one column in your #df_ERA4_c destination table is because you only include but one column named CONCAT_COL in your select list. If you need all columns followed by CONCAT_COL then all you need to do is add all columns to the list:
This script should produce desired result.
Hope this helps.
answered Nov 14 at 01:50 PM