Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527

    Unanswered: Can I manipulate the result set of a sproc?

    I need to call a sproc but just return a couple of the columns in the result set. I can't alter the original sproc. Is this possible? Something like the following would be great but I don't think it's possible:

    select col1, col3 from ( exec the_sproc )

    I can obviously create a copy of the sproc and just alter the output or put the output in a separate table before selecting out or just call from PERL etc and manipulate the output there but "they" don't want that.

  2. #2
    Join Date
    Jun 2010
    Posts
    51
    select col1, col3 from ( exec the_sproc )
    This is not possible in sybase 12.5.

  3. #3
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    cheers - I thought not but hope springs eternal.

Posting Permissions

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