this is the new query with SET statement

CREATE PROCEDURE [dbo].[PS_DIM_MATERIEL]

AS

BEGIN

Truncate table DWProd.dbo.DIM_MATERIEL

INSERT INTO DWProd.dbo.DIM_MATERIEL

(ID_MATERIEL,

LIB_MATERIEL,

CODE_MATERIEL,

TYPE_MATERIEL,

MARQUE_MATERIEL,

MODELE_MATERIEL,

PUISSANCE,

VALEUR_ACHAT,

FOURNISSEUR,

DATE_ACHAT_MATERIEL,

DATE_DEBUT,

IMMATRICULATION,

ID_EXP,

NOM_EXP,

PROPRE_DNE_LOCATION

)

SELECT MATERIEL.ID_MATERIEL,

MATERIEL.LIB_MATERIEL,

CODE_MATERIEL,

MATERIEL.LIB_TYPE_MATERIEL AS TYPE_MATERILE,

MATERIEL.LIB_MARQUE_MATERIEL AS MARQUE_MATERIEL,

MATERIEL.MODELE_MATERIEL,

CONVERT(real,ISNULL(MATERIEL.puiss,0)) AS PUISSANCE,

CONVERT(real, ISNULL(MATERIEL.Valeur,0)) AS VALEUR_ACHAT,

MATERIEL.Fourn AS FOURNISSEUR,

SET LANGUAGE French

CONVERT(datetime,MATERIEL.Datach) AS DATE_ACHAT_MATERIEL,

MATERIEL.D_MATERIEL AS DATE_DEBUT,

MATERIEL.Immatr AS IMMATRICULATION,

MATERIEL.ID_EXP,

NOM_EXP,

[PDNEL]

FROM

SOURCE.AGE.MATERIEL MATERIEL INNER JOIN

SOURCE.AGE.EXP EXP

on EXP.ID_EXP=MATERIEL.ID_EXP

END

GO

and this is the message error :

Msg 156, Level 15, State 1, Procedure PS_DIM_MATERIEL, Line 36

Incorrect syntax near the keyword 'SET'.

Msg 156, Level 15, State 1, Procedure PS_DIM_MATERIEL, Line 37

Incorrect syntax near the keyword 'CONVERT'.