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 Mike Lewis 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. maddyforums

    Concatenation of multiple rows into a single row (sybase)

    Thanks a lot for sending me the query. I have 232000 records in the S1 table with similar type of data and also found that the Seq_no can be more even though the max seq_no is 2 at present. Is it possible to generalize this query? What is the complexity involved? Thanks Maddy
  2. maddyforums

    Concatenation of multiple rows into a single row (sybase)

    Thanks PDreyer, the max seq_no is 2. Can you please send me the query for this ?
  3. maddyforums

    Concatenation of multiple rows into a single row (sybase)

    Can someone please help me out in writing the Sql to concatenate the Text_desc for each code for all the seq_nos in the ascending order of seq_no and load into the target table. Source table : S1 Code Seq_no Text_desc --------------------------- 1579 0 BCN5, CO20, ER75 1579...

Part and Inventory Search

Back
Top