El_Mou (5/9/2013)
Truncate table DWProd.dbo.DIM_MATERIELINSERT 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,
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
The above query doesn't have SET LANGUAGE statement (or any other SET statement), so it can not possibly produce an error:
when i do it they give me this message :
Msg 156, Level 15, State 1, Procedure PS_DIM_MATERIEL, Line 35
Incorrect syntax near the keyword 'SET'.