> Pls do bother to read the following:
>
> Insert into <table name>
> ( col1,
> col2,
> .......,
> coln
> )
> select (
> <value>,
> <value>,
> ...........,
> XXX
> )
> from <table name>
>
> We are inserting 100 or whatever no of rows in the table.And, in place
> of XXX, we need to call a sp and the output will be stored in coln.
>
> How we could do this?
> What we definitely require is to put the the output value of sp in coln
> when we insert rows in the table.
> If you have any better way to do this , pls pls share with us.

"Mukut" <hidevraj@gmail.com> wrote in message
news:1158380480.799126.158190@i42g2000cwa.googlegroups.com...
> All,
>
> Pls do bother to read the following:
>
> Insert into <table name>
> ( col1,
> col2,
> .......,
> coln
> )
> select (
> <value>,
> <value>,
> ...........,
> XXX
> )
> from <table name>
>
> We are inserting 100 or whatever no of rows in the table.And, in place
> of XXX, we need to call a sp and the output will be stored in coln.
>
> How we could do this?
> What we definitely require is to put the the output value of sp in coln
> when we insert rows in the table.
> If you have any better way to do this , pls pls share with us.
>
> Thanks ,
> Mukut
>