Home Forums SQL Server 2008 SQL Server Newbies why is this trigger not working ? RE: why is this trigger not working ?

  • January 16, 2017 at 10:36 pm

    #1923103

    I have tried another way :
    I have created a stored procedure  [dbo].[sp_timedifference] 
    and in it :

  • update JOURNAL set DIFF=
    CONCAT((DATEDIFF(Minute,start_date,

    • [end_date])/60),':',
                 (DATEDIFF(Minute,start_date,[end_date])%60))

      and a trigger with :

  • [dbo].[trg_timediff] on [dbo].[JOURNAL]
     for insert,update
     as
    exec sp_timedifference;

    • Is this OK ?