All,
I've been using stored procedures for a while now but I've never really
needed to create one that returned multiple result sets. My question is,
how do you do that? Would someone be kind enough to show me a little
pseudo code or a snippet of code on how to accomplish this?
I assume in cf, I would build my cfstoredproc like this:
<cfstoredproc procedure="procedure_name" datasource="#maindsn#">
<cfprocresult name="result1">
<cfprocresult name="result2">
</cfstoredproc>
But I draw a blank when it comes to building the stored proc in SQL
Server where it would return multiple results. I assume the following:
create procedure [procedure] as
select ... from ... where...
select ... from... where...
How do I specify what query goes with what result?
Thanks for your help!
Mark
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
