Passing query results to a stored procedure

  • Hi all,

    I have a stored proc on my system which allows me to enter a number and it returns a list of related numbers. I have a query which produces a list of numbers for me to use with this sp. Is there any way of passing the results of that query directly to the SP to get the list of related numbers?

    TIA

  • Is there a reason to not just include the query in the proc? Procs can call other queries.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • "I have a stored proc on my system which allows me to enter a number and it returns a list of related numbers"

    Can you convert that into a function?

  • If you want to provide a table (list) to a procedure, this will be a new feature in SSE2k8 but is not available in SSE2k5.

  • Hi can u post your SP source code and how are you calling this to get more insight on your process.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply