Comma Separated Value (T-SQL Query)

• EasyBoy

  SSCertifiable

  Points: 5301

  More actions

  January 18, 2011 at 7:04 am

  #388657

  create table hp

  (id int,

  name varchar(30))

  insert into hp values (1,'HP')

  insert into hp values (2,'HP')

  HP1

  HP2

  Actually i want value like HP ,1, 2 (one row rather than 2 rows)

  Can anyone let me know how can i get that?

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  January 18, 2011 at 7:32 am

  #1274719

  select name, min(id) , max(id)

  from hp

  group by name

• WayneS

  SSC Guru

  Points: 95460

  More actions

  January 18, 2011 at 9:20 am

  #1274820

  Did you see this article?[/url]

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• baabhu

  SSCertifiable

  Points: 6205

  More actions

  January 21, 2011 at 1:07 am

  #1276406

  Plesae use this.

  SELECT name, ID, COUNT(*) as CNT

  FROM hp

  Group by name, ID