CREATE PROCEDURE dbo.CreateTempT40
@VerPlanPar int,
@StrPar varchar( 400 )

AS

Delete From TempT40

EXEC('INSERT INTO TempT40 ( IZD, HH, Norma, CEX, cex_cput )
SELECT PL.IZD, T40A.HH, T40A.HOPMA AS Norma, T40A.CEX, 0 AS cex_cput
FROM VerPlan INNER JOIN ((PL INNER JOIN H34A ON PL.IZD = H34A.IZD) INNER JOIN T40A ON H34A.IZD = T40A.IZD) ON VerPlan.ID_VerPlan = PL.ID_VerPlan
WHERE ((((H34A.PCIZD)=0) AND(T40A.CEX)<>2) AND ((VerPlan.ID_VerPlan)=' + @VerPlanPar +')) 
AND (VerPlan.mto = 1)  '  + @StrPar +  ' 
ORDER BY PL.IZD, T40A.HH, T40A.CEX;')
GO