SQL Combine Multiples Records of a Column Comma Separated Into One (csharpdotnetfreak.blogspot.com)

submitted by amit.jainamit.jain(1186) 2 years, 10 months ago

n this example i am going to describe how to combine multiple records of a column in MS SQL into one record comma separated. Here is the scenario I have a table having Employees names and their respective Department names, now i want to show Employees names separated by comma into one column and respective Department name in another column.

add a comment |category: |Views: 88

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

No comments so far

information Login or create an account to comment on this story