|
|
 |
 |
 |
 |
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 ...
> 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.
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:
> 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 :)
|
 |
 |
 |
 |
|
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc