User Profile

Collapse

Profile Sidebar

Collapse
Iprogramforlawyers
Iprogramforlawyers
Last Activity: May 24 '06, 04:49 PM
Joined: May 2 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Iprogramforlawyers
    replied to How do I combine multiple rows into one row sql?
    in General
    Hmmm



    I'm a little further along, and what you've said isn't what I'm looking for.

    Basically I need to take every note one of our users may or may not have left and combine that and some other fields into one giant text field so it can be exported to a new program the lawyers are using.


    So I thought I could cursor through the notes combing as I go and came up with this:
    ...
    See more | Go to post

      Leave a comment:

    • Iprogramforlawyers
      started a topic How do I combine multiple rows into one row sql?
      in General

      How do I combine multiple rows into one row sql?

      I need to take any amount of rows and turn them into one single row. I'm exporting some data from sql. The program its going into only has one note field. I've used UNION and those types of functions, not sure what to do this time. This is SQL server and will be part of a stored procedure.

      example data:

      NOTES NOTE TIME
      yayayay hey yo 4/25/2006
      blah blah blaaah ...
      See more | Go to post
      No activity results to display
      Show More
      Working...