declare @p1 int set @p1=5 exec sp_prepare @p1 output,N'',N'SELECT T1.C2, T0.C0, T0.C1, T0.C2, T1.C3, T0.C3 FROM ( SELECT TOP 100 "Test"."MonthDt" AS C0, "Test"."SaleDt" AS C1, "Test"."ProductCd" AS C2, SUM("Test"."Qty") AS C3 FROM "dbo"."Test" GROUP BY "Test"."SaleDt", "Test"."MonthDt", "Test"."ProductCd" ) T0 LEFT OUTER JOIN ( SELECT DISTINCT TOP 100 "Test"."ProductCd" AS C0, "Test"."MonthDt" AS C1, SUM("Test"."Qty") AS C2, SUM("Test"."Qty") AS C3 FROM "dbo"."Test" GROUP BY "Test"."MonthDt", "Test"."ProductCd" ) T1 ON T0.C2 = T1.C0 AND T0.C0 = T1.C1',1 select @p1