How to display Multiple row data to insert into one row

• shakir-769418

  Old Hand

  Points: 309

  More actions

  August 19, 2008 at 5:56 am

  #191451

  My data is bellows::

  DateItem_IDItem_Name Sales_Parson

  19-Aug1005Mouse Shakir Hossain

  19-Aug1005Mouse Shakir Hossain

  19-Aug1005Mouse Kabir Khan

  19-Aug1008Key Board Sibbir Ahmed

  19-Aug1008Key Board Sibbir Ahmed

  19-Aug1008Key Board Shakir Hossain

  and I want to generate like this query::

  DateItem_IDItem_NameSales_Parsons_Name

  19-Aug1005Mouse Shakir Hossain, Kabir Khan

  19-Aug1008Key BoardSibbir Ahmed, Shakir Hossain

  Please Help Me...!! I am in big big trouble....

  anybody can help me...!!

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 19, 2008 at 7:38 am

  #860014

  Search this site for "Tame Those Strings". There is a series of articles on string manipulation and one is about doing what you need to do.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question