mardi 23 décembre 2014

How to concatenate the different row values in to one row in SQL Server [duplicate]


This question already has an answer here:




I have Table A with columns CompetenceId, Description and Development Action. This is Table A


enter image description here


I have another table B with CompetencyId and Development Action.


enter image description here


As each CompetenceID is having multiple development actions in table B. My requirement is for 'Table A' I need 'Development action' column for a particular competencyId in the same row up on joining Table B. The result should look like below for Table A


enter image description here


How can I achieve this? Thanks in advance


Aucun commentaire:

Enregistrer un commentaire