Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. johnstern

    Help with query concatenate data from a second table

    thank you very much for taking the time to put this together forgive my ignorance but what does it mean ANSI. are you indication that is not possible to write a query like this ? please see Pseudo code below -- select id, username, ( select @skills1 = coalesce(@skills1 + ',', '') +...
  2. johnstern

    Help with query concatenate data from a second table

    sql server 2005
  3. johnstern

    Help with query concatenate data from a second table

    I have table users IDuser Name 1 John 2 Peter 3 JOsh IDuser Skills 1 typist 1 acct 3 driver 3 Guard I need to write a query that will show as follows ID NAME SKILLS 1 John typist,acct 3 Josh Driver,Guard

Part and Inventory Search

Back
Top