Results 1 to 2 of 2

Thread: SQL 2005 combining records into one

  1. 03-02-2008, 08:02 AM #1
    chapo
    chapo is offline Registered User
    Join Date
    Feb 2008
    Posts
    3

    SQL 2005 combining records into one

    Could some one please help me with the following query.

    I have multiple tables link together that I have select distinct base on wo_No and prt_Mark and I get the following results
    [wo_No] [prt_Mark] [dwg_Seq]
    [324037] [d400] [1S2]
    [324037] [d400] [A1]
    [324037] [d400] [1]

    What I would like is to combine all the different dwg_Seq into one field.
    [324037] [d400] [1S2, A1, 1]

    Any help would be greatly appreciated.
    Reply With Quote Reply With Quote
  2. 03-11-2008, 09:08 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    you could create a function like in this

    http://www.databasejournal.com/scrip...le.php/2243951
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules