For sql server temp table the way klinton described should work.
"Klinton Lee" <[EMAIL PROTECTED]> wrote:
>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]
