/*

INSERT INTO #tmpTable
SELECT blabla FROM abc 
LEFT JOIN 123
LEFT JOIN 123
LEFT JOIN 123
LEFT JOIN 123
....

*/

SET @sql = 'SELECT ' + @FieldList + ' FROM #tmpTable ' + 'GROUP BY ' + @FieldList
EXEC sp_Executesql @sql