المساعدة كمل view ب procedure مع variable

ممكن تصحيح

create  proc gggggg
(
@date1 as datetime,@date2 as datetime
)
 as
begin
DECLARE @DynamicPivotQuery AS NVARCHAR(MAX)
SET @DynamicPivotQuery =
  N'create VIEW DV_D_T_E
  AS
  SELECT dr.Id_Recep,prd.Nom_Produit,sum(Poid_Reel) as pr
 FROM Detail_Recep AS DR
 INNER JOIN Bon_Recp AS BR ON BR.Id_Recep=DR.Id_Recep
 INNER JOIN  Especes  AS ESP ON ESP.N_Especes=DR.N_Especes
 INNER JOIN Produit  AS prd ON prd.N_Produit=ESP.N_Produit
 WHERE BR.Date_Bon_Recep BETWEEN ' + @date1 + ' AND ' + @date2 + '
  GROUP BY dr.Id_Recep,prd.Nom_Produit'
  EXEC sp_executesql @DynamicPivotQuery
end
EXEC gggggg '01/01/14', '01/03/14'

عند التنفيد يكون خطاء