You can create stored procedure to place your results in a temporary table,
(or results table).
Then select the final results from there.
Ie.
select into #workarea select a,b,c from table1;
insert into #workarea select a,x,y from table2;
select f1, f2, f3 from #workarea;
Although, I don't recall how ND handles temp tables...;)
So, you may want to create a 'real' results table.
delete results
insert into results select a,b,c from table1;
insert into results select a,x,y from table2;
select f1, f2, f3 from #workarea;
If you use the above options, the select into bulkcopy option must be turned
on.
klint
> -----Original Message-----
> From: Rodriguez, Sergio [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 02, 1999 4:09 PM
> To: [EMAIL PROTECTED]
> Subject: [ND] Stored Procedures
>
>
> Hi all,
>
> I'm using a store procedure on SQL Server 6.5 and I'm having the following
> problem.
>
> The store procedure is something like this.
>
> // Select 1
> Select a, b, c From table1
>
> // Select 2
> Select a, x ,y From table2
> GO
>
>
> Know, from NetDynamics when I create the DataObject and execute it I just
> got the results from the first select (Select 1)
>
> My question is, Is there any way to get the results from the 2 selects.
>
> Thanks in advance.
> _________________________________________________________________________
>
> For help in using, subscribing, and unsubscribing to the discussion
> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
> For dire need help, email: [EMAIL PROTECTED]
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
