Use XML path in SQL Server 2012 with a temp table?
I am on version 2012 and need to use the XLM path to get a common separated string for like projects. I have a temp table that I have compiled and would like to combine people based on project numbers. The results combine all people into one list for all projects. I am looking to get specific to project.
Can anybody help use XML path in MS SQL 2012 with a temp table?
I am on version 2012 and need to use the XLM path to get a common separated string for like projects. I have a temp table that I have compiled and would like to combine people based on project numbers. The results combine all people into one list for all projects. I am looking to get specific to project.