I have modified the #tab1_audit and included one more column name as 'Row_number'.

(i) When a update trigger inserts row into this #tab1_audit, both old and new (Modified) rows will...

Hi LutzM,

Thanks for your solution.

Now we are getting the result as follows:

----------------------------------------------------------------------------------

part_id adt_ts pay_clct_amccy_cd

----------------------------------------------------------------------------------

1002 4/8/11 10:29 AMold:-10800.000000000, new:-11880.000000000unchanged

1002 ...

Hi Patrick,

Please do some changes. Because no alias for 'I'

~~~~~~~~~~~~~~~~~~~~

l.territory_code as storecode,

and l.loc_id = '109'

~~~~~~~~~~~~~~~~~~~~

The above should be

L.territory_code as storecode,

and L.loc_id = '109'

Regards,

Ganapathi M

Hi Patrick,

In the above I refers to which table?

l.territory_code, l.loc_id

Ganapathi M

Hi Experts

Thanks for your reply... 🙂

Ganpat

10/2  = 5

10%2 = 0

% is called Modulo division. It will gives us the Quotient value. In our example 

Quotient is 0 suppose if i...

Thanks Markus,

Its Working!!!

Ganapathi.