0

Could any one please help regarding issue in SQL Server I have a query which returns 4 counts with different Objid. I want to merge them based on objid & value separated with a comma (,)

enter image description here

enter image description here

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
kajal
  • 1
  • 1
  • 1
    Please post what you've tried so far. – BJones Oct 26 '17 at 14:12
  • 1
    Post the code, text in the question itself. Don't post links to images. SQL Server 2017 added a STRING_AGG method. SQL Server 2016 added STRING_SPLIT. There are a lot of duplicates that show how to do the same with earlier versions – Panagiotis Kanavos Oct 26 '17 at 14:13
  • 1
    DON'T DO THIS THIS! Never ever **ever** store delimited data in an sql column. – Joel Coehoorn Oct 26 '17 at 14:13
  • This is what i tried but facing other issue thats why i want it in differnt manner.https://stackoverflow.com/questions/46954303/duplicate-record-in-sql-server – kajal Oct 27 '17 at 05:35

0 Answers0