yes you were right ! thank you !

THANKS FOR YOUR HELP

BUT NOW I WANT TO CALCULATE THIS FIELD IN MY SSRS REPORT

HOW CAN I PUT IT THERE ? I FOUND JUST 3 FONCTIONS : SWITCH...

its not the best practice to create a calculated field by calling this stored procedure

so this is my context : i have a rapport who work perfectly but...

CAN YOU EXPLAIN...

ITS DONE NOW ! thanks for your help EUGENE

i verify and i cant find the values :s im really lost !

this is the table DIM_TEMPS :

CREATE TABLE [dbo].[DIM_TEMPS](

[DATEID] [datetime] NOT NULL,

[JOUR] [int] NULL,

[JOUR_SEMAINE] [int] NULL,

[SEMAINE] [int]...

what i said about SP script's is valable for the table destination they came from the production on the same DW

but effectively your right i think i see...

yes i set the language i did it but still having the same message error

its supposed work fine ( of course with setting the language in conversion datetime...

so the first month of the year in this enterprise is October(10) and finish September (9)

( that's called CAMPAGNE its mean Crop year if i can trust Google translate :D...

before i expose whats the requirement of this script to thank you Eugene for your help

thanks you so much EUGENE for your precious help its done now for all the table who had similar message error

but still have another error with a dimension_time generate...

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,

...

Truncate table DWProd.dbo.DIM_MATERIEL

INSERT INTO DWProd.dbo.DIM_MATERIEL

(ID_MATERIEL,

LIB_MATERIEL,

CODE_MATERIEL,

TYPE_MATERIEL,

MARQUE_MATERIEL,

...

i typed back up my DW and i do it , but i meant restore my DW :w00t:

the coffee machine is out service this week and i cant concentrate on...

thanks eugene no i have just one language

first im gonna back up my DW because i made a lot of modifications especially to ignore conversion to datetime because its...