Checking ASE errorlog
Tue Nov  23   09 : 30 : 12  EST  2010 
Server=PROD_LIT2
Errorlog=/home1/dmlprd213/sybase/ASE-12_5/install/PROD_LIT2.log

 00 : 00000 : 00171 : 2010 / 11 / 22   12 : 24 : 03 . 52  server  Deadlock Id  144  detected
Deadlock Id  144 : detected.  1  deadlock chain(s) involved.
Deadlock Id  144 : Process (Familyid  0 , Spid  452 , Suid  7110 ) was executing a UPDATE command in the trigger 'uTranchePerf_trg' at line  24  at nested level  3 .
Deadlock Id  144 : Process  452  was involved in application 'DRAW'.
Deadlock Id  144 : Process  452  was involved on host name '<none>'.
Deadlock Id  144 : Process  452  was involved in transaction '$upd'.
Deadlock Id  144 : Process (Familyid  0 , Spid  171 , Suid  6450 ) was executing a SELECT command in the procedure 'sa_rmbs_tranche_custm' at line  221  at nested level  1 .
Deadlock Id  144 : Process  171  was involved in application '<none>'.
Deadlock Id  144 : Process  171  was involved on host name '<none>'.
Deadlock Id  144 : Process (Familyid  0 , Spid  171 ) was waiting for a 'shared page' lock on page  104909  of the 'TranchePerf_new' table in database  21  but process (Familyid  0 , Spid  452 ) already held a 'exclusive page' lock on it.
Deadlock Id  144 : Process (Familyid  0 , Spid  452 ) was waiting for a 'exclusive intent' lock on the 'tranche_master' table in database  21  but process (Familyid  0 , Spid  171 ) already held a 'shared intent' lock on it.
Deadlock Id  144 : Process (Familyid  0 , Spid  452 ) was chosen as the victim. End of deadlock information.

        1  Deadlock(s) found in errorlog for ASE server 'PROD_LIT2'

(end)

create trigger uTranchePerf_trg
    on TranchePerf_new
   for update
as
BEGIN
     update tranche_master set
            curr_balance = case when tm.cash_flow='IO' then  0 . 0 
                                else isnull(convert(float,i.balance), 0 . 0 )
                           end,
            curr_date = i.reportingDate
       from dbo.tranche_master tm, inserted i
      where tm.tranche_id = i.inveInstId
        and i.reportingDate >=( select max( reportingDate )
                                from dbo.TranchePerf_new p (index x2)
                                where p.inveInstId = i.inveInstId )
        and i.reportingDate = ( select max( reportingDate )
                                from inserted i2
                                where i.inveInstId = i2.inveInstId )
        and (
               (tm.curr_balance IS NULL) OR
               (ABS(tm.curr_balance - isnull(i.balance,  0 . 0 )) >=  0 . 0001 )OR
               (tm.curr_date IS NULL) OR
               (tm.curr_date != i.reportingDate)
            )
END