Results 1 to 5 of 5

Thread: How can we write the columns set as rows set?

  1. 04-23-2008 #1
    nageshkota
    nageshkota is offline
    Contributing Member
    Join Date
    Apr 2008
    Answers
    31
    Send a message via Yahoo to nageshkota

    Post How can we write the columns set as rows set?

    With Out Using The Temporary tables(# tables).

    Reply With Quote Reply With Quote
  2. 04-23-2008 #2
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas How can we write the columns set as rows set?

    Re: How can we write the columns set as rows set?

    You can try that using case statment.

    Reply With Quote Reply With Quote
  3. 04-23-2008 #3
    nageshkota
    nageshkota is offline
    Contributing Member
    Join Date
    Apr 2008
    Answers
    31
    Send a message via Yahoo to nageshkota

    Re: How can we write the columns set as rows set?

    Quote Originally Posted by debasisdas View Post
    You can try that using case statment.

    If we know the columns set then only we can use the case statement, if did not know the column set then what is the way to get?

    Reply With Quote Reply With Quote
  4. 04-23-2008 #4
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas How can we write the columns set as rows set?

    Re: How can we write the columns set as rows set?

    If you want to do it dynamically better to use Procedure for that .

    Reply With Quote Reply With Quote
  5. 04-29-2008 #5
    dinesh_b5
    dinesh_b5 is offline
    Junior Member
    Join Date
    Apr 2008
    Answers
    1

    Re: How can we write the columns set as rows set?

    Hi all i am new to this forum ...

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact