• How about = instead of 'AS'

    create view dbo.GlobaldataEOLT2

    as

    select [NUMCAM]

    ,[C_Fourn]

    ,[date_passage]

    ,[heure_passage]

    ,[banc]

    ,[NUMPale]

    ,[Module_Status]

    ,[Code_defaut]

    ,[Total_TestTime]

    ,[Purgerunin_TestTime]

    ,[ShifterPosHyst_TestTime]

    ,[ShifterActRespTime_TestTime]

    ,[GearActStroke_TestTime]

    ,[GearActRespTime_TestTime]

    ,[LeakageON_TestTime]

    ,[K1K2Leakage_TestTime]

    ,[QPVK1DeliveryTest_TestTime]

    ,[PPVK2PressureTest_TestTime]

    ,[LeakageOFF_TestTime]

    ,[PRVTest_TestTime]

    ,[OPS_NRV_Test_TestTime]

    ,[version_prog]

    ,[Jourprod] =

    CASE WHEN heure_passage BETWEEN '00:00:00' and '05:59:59' THEN day(jour_passage) -2

    ELSE day([date_passage]) -1

    END

    FROM dbo.T_EOLT_BRUTE_FLOAT

    or

    CASE WHEN heure_passage BETWEEN '00:00:00' and '05:59:59' THEN day(jour_passage) -2

    ELSE day([date_passage]) -1

    END as [Jourprod]