How to write a query for audit table?
I have to get OLD_Value and NEW_Value
This is my table:
Tabel : 1
BusinessEntityID int PRIMARY KEY
RateChangeDate datetime
Rate money
PayFrequency tinyint------ > Have to change this column
ModifiedDate datetime
Tabel : 2
BusinessEntityID int PRIMARY KEY
Old_Value tinyint
New_Value tinyint
ModifiedDate datetime