Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Need Help


Can anyone help me on this ?

I have executed a stored procedure i have got a resultset , i have to
add all the values of that result set to the target table.

Regards,
Venu S.

Hi

I belive you talking about getting the result from stored procedures and
insert into a table, am i right ? try

insert into #table
exec('exec YourStoredproc')

VT
Knowledge is power, share it....
http://oneplace4sql.blogspot.com/

"venus" <venusindi@gmail.com> wrote in message

news:1180430694.396698.218830@g37g2000prf.googlegroups.com...

On 5 29 , 5 24 , venus <venusindi@gmail.com> wrote:

> Can anyone help me on this ?

> I have executed a stored procedure i have got a resultset , i have to
> add all the values of that result set to the target table.

> Regards,
> Venu S.

insert into tablename
exec procname
then destination table must be created first :)

-----------------------------------------------Reply-----------------------------------------------
Thanks to all for the reply.

I will check and will let you know.

Regards,
Venu S.
On May 29, 3:25pm, xyb <xiangyua@gmail.com> wrote:

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc