Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: transforming a resultset

    hi all

    i'm doing a simple select statement and the results are being displyaed like this

    firstname lastname id type phone
    Joe Blogs 1 Work 0123456789
    Joe Blogs 1 Home 9876543210

    I want the results deisplayed in one line for each person, like this

    firtname lastname id typework typehome
    Joe Blogs 1 0123456789 9876543210

    Can someone show me how i would do this, would i need to write a cursor to transform the data'?

    thanks for any help

  2. #2
    Join Date
    Jan 2004
    fixed this now

Posting Permissions

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