'How can I convert varchar (1,2,3) to a correlating column values name in SQL Server 2014?

I have an issue with converting a varchar column filled with id's (foreign keys) to another string with names, these names are linked in another table with their correlating id.

Data

 x-----x------------------------x
 | Id  | foreign Keys (varchar) |
 x-----x------------------------x
 |  1  |  1,2,3                 |
 |  2  |  2,3,4                 |
 |  3  |  4                     |  
 x-----x------------------------x

Names

 x-----x-----------------x
 | Id  |  Names (varchar)|
 x-----x-----------------x
 |  1  |  Rick           |
 |  2  |  Steven         | 
 |  3  |  Charly         |
 |  4  |  Tom            | 
 x-----x-----------------x

Basically I need the values in the table data to UPDATE to a varchar like 'Rick, Steven, Charly'.

I am working in SQL Server 2014, so I can't use the function STRING_SPLIT.

Help would be really appreciated

Thanks

sqlsql-server-2014


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