sql server - SQL INSERT @tableVar SELECT ... is only insert -

i need fill dataset values several tables.

i've created stored procedure executes several select statements.

each select has common parts.

i decided cache results of these common parts.

now need select construct capable of outputting results table variable.

insert @tablevar select ... inserts data not select it.

my intention select * output selected.* @tablevar ...

is possible perform such operation?

insert @tablevar    output inserted.*    select *    [...]