Hi,
Your question is not very clear.. Are you looking for a in-memory table?
In that case you can go ahead with
a) Common table expression(Sql Server 2005+) e.g.(with cte as (//code))
b) Table variables e.g.(declare @tbl Table(col1 int,col2 nvarchar(max))
c) Temporary table(#temp or ##temp)
d)Table Valued Parameter(Sql server 2008+)
etc.
Else, issue the create table command followed by insert into tablename values(value1,value2...value n) or insert into..select command
Hope this helps
2
