把存儲過程的數據寫入table

create  table randomtable (CustomerItem  varchar(100) )

insert randomtable exec(@sql)--proc name
select * from randomtable
drop table randomtable