SQL Server Performance

db one to many relationship problem

Discussion in 'General Developer Questions' started by smily, Sep 1, 2003.

  1. smily New Member

    Hi Friends,<br /><br />I have a table with one to many relationship, <br /><br />So my view looks like some thing like<br /><br /><br />Firstname Lastname contacttypevalue<br />-------- ------- ----------------<br /><br /><br />firstname1 Lastname1 12345 (phone day)<br />firstname1 Lastname1 343566 (phone evening)<br />firstname1 Lastname1 12345 (mobile)<br />firstname1 Lastname1 324324 (fax)<br />firstname1 Lastname1 aaa@aa.com (email)<br />firstname1 Lastname1 www.help.com (web address)<br /><br />I would like to get something<br /><br />like this<br /><br />firstname1 Lastname1 12345 (phone day)<br /> 343566 (phone evening)<br />12345 (mobile)<br />324324 (fax)<br />aaa@aa.com (email)<br />www.help.com (web address)<br />do i need to write the cursor or anything ...... Please let me know<br /><br />Smily<br /><br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' />
  2. Twan New Member

    I'd suggest doing this sort of thing client-side rather than server side... so in the .asp or what ever language you're using

    Cheers
    Twan
  3. satya Moderator

    Smily, kindly do not post multiple(duplicate) posts.
    I have deleted other post in General DBA forum.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page