Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    1

    Unanswered: SQL to convert rows into columns

    Hi,

    I have the data in the below format.
    Date ID SuBJECT MARKS STATUS
    11/07/2012 123 ENGLISH 70 PASS
    11/07/2012 123 ECONOMIC 80 PASS
    11/07/2012 123 HISTORY 30 FAIL
    11/07/2012 456 ENGLISH 56 FAIL
    11/07/2012 456 ECONIMIC 32 FAIL
    11/07/2012 456 HISTORY 40 FAIL



    i want the output in below format
    DATE ID ENGLISH ECONOMIC HISTORY STATSU
    11/07/2012 123 70 80 30 PASS&FAIL
    11/07/2012 456 56 32 40 FAIL

    Please help me in resloving this ....

  2. #2
    Join Date
    Jul 2012
    Posts
    15
    I think this thread might help you: http://www.dbforums.com/sybase/16309...ingle-row.html

Posting Permissions

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