I have a table variable which i use to collect records from several tables, which have to be processed later on in my query. It look a bit like this: DECLARE @Prices TABLE ( ProductId INT, ...