Memory tables

The below is an example of how to create a table in memory. This can then be updated or joined to other tables before return back to the calling method.

        
DECLARE @MemoryTable TABLE (Col1 int, Col2 varchar(150), Col3 varchar(150));  

INSERT INTO @MemoryTable (Col1, Col2, Col3 )(  
SELECT	 
CategoryID AS Col1,  
Message AS Col2,  
Name AS Col3 
FROM	ForumMessages  	 
);