"thirdman" <takayasu.harada@csfb.com> wrote in message
news:ded5ab9.0401291140.189617db@posting.google.co m...
> I'm trying to write a SQL that stores a result from a stored-procedure
> into a temporary table.
>
> Is there any way of doing this?


1) Create table test (
col001 varchar(10) null
)
go

2) insert into test
select substring(description,1,10)
from someothertable