April 9, 2009 at 9:10 am
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
April 9, 2009 at 9:11 am
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
April 9, 2009 at 10:22 am
"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?
April 9, 2009 at 10:33 am
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.
April 10, 2009 at 9:37 am
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