Results 1 to 5 of 5

Thread: Nested Stored Procedures

  1. Jan 8th, 2003, 05:11 AM #1
    Leather
    Leather is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2002
    Location
    SE England
    Posts
    732

    Nested Stored Procedures

    Does anyone know how to work out what recordset was returned (IE: Field names & Data types) from within another stored procedure?

    IE

    SP 1 calls SP2 and needs to analyze its results...

    NOTE: I realise that Output parameters can be used, but this is not an option here as all of the lower level (In this case SP2) stored procedures have already been written.. Now I need a way to analyze what they return.
    Last edited by Leather; Jan 8th, 2003 at 05:17 AM.
    Leather Face is comin...


    MCSD
    Reply With Quote Reply With Quote
  2. Jan 8th, 2003, 05:16 AM #2
    Lightning
    Lightning is offline
    Frenzied Member Lightning's Avatar
    Join Date
    Oct 2002
    Location
    Eygelshoven
    Posts
    1,611
    Give each record a unique key, and pass that value to the other
    Reply With Quote Reply With Quote
  3. Jan 8th, 2003, 05:20 AM #3
    Leather
    Leather is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2002
    Location
    SE England
    Posts
    732
    Sorry I don't get that?
    Leather Face is comin...


    MCSD
    Reply With Quote Reply With Quote
  4. Jan 8th, 2003, 06:16 AM #4
    Leather
    Leather is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2002
    Location
    SE England
    Posts
    732
    /\ BUMP /\
    Leather Face is comin...


    MCSD
    Reply With Quote Reply With Quote
  6. Jan 9th, 2003, 04:29 AM #5
    Leather
    Leather is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2002
    Location
    SE England
    Posts
    732
    /\
    /--\
    /----\
    /------\
    Leather Face is comin...


    MCSD
    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


Click Here to Expand Forum to Full Width