SQL Experts Please Help

[nene_nani]

DoctorName	Address	Phno	mobileno	ModifiedDate
John	123MainStreet	7477474747	334348484	01/01/2017
John	123MainStreet	8477474748	444433333	01/03/2017
John	404LinconnHwy	8477474748	666666666	01/05/2017
John	999GregorySquare	8477474748	666666666	01/07/2017

Table: Doctor_History

 

I have a Doctor History table, each time doctor update his information it inserts a record in History table

My requirement is:  I need to create a report “what are the columns changed and Value before and after for that column“

Please see the Final Output report below:

 

 

DoctorName	Modified date	Column  Changed	Field before Value	Field After Value
John	01/03/2017	Phno	7477474747	8477474748
john	01/03/2017	mobileno	334348484	444433333
john	01/05/2017	Address	123MainStreet	404LinconnHwy
john	01/05/2017	mobileno	444433333	666666666
John	01/07/2017	Address	404LinconnHwy	999GregorySquare

 

    Please help me.                                                           

[nene_nani]

LTT

[former]

do you need query to get this output or do you have any reporting platform?

[nene_nani]

I need a Query.. i dont have any reporting platform..

[nene_nani]

LTT

[BillMarkSteve]

Try after update trigger...google for examples...

[nene_nani]

LTT

[gudboy999222]

select dh.* from doctor d, doctor_history dh
where d.name=dh.name

idi motham records istadi.. tarvata nuvvu sort out chesuko ememi kaavalo.. order by use chesuko, date desc or asc ...

[nene_nani]

LTT

[LivingLegend]

Paina cheppina solutions Ki reply ivvu man. Did you check those ?

[lingamaneni111]

4 hours ago, nene_nani said:

DoctorName	Address	Phno	mobileno	ModifiedDate
John	123MainStreet	7477474747	334348484	01/01/2017
John	123MainStreet	8477474748	444433333	01/03/2017
John	404LinconnHwy	8477474748	666666666	01/05/2017
John	999GregorySquare	8477474748	666666666	01/07/2017

Table: Doctor_History

 

 

 

I have a Doctor History table, each time doctor update his information it inserts a record in History table

 

My requirement is:  I need to create a report “what are the columns changed and Value before and after for that column“

 

Please see the Final Output report below:

 

 

 

 

DoctorName	Modified date	Column  Changed	Field before Value	Field After Value
John	01/03/2017	Phno	7477474747	8477474748
john	01/03/2017	mobileno	334348484	444433333
john	01/05/2017	Address	123MainStreet	404LinconnHwy
john	01/05/2017	mobileno	444433333	666666666
John	01/07/2017	Address	404LinconnHwy	999GregorySquare

 

 

    Please help me.                                                           

 

endih baa mee company , DB logs meedha rapisthada? archive logs chusin code chesthara?

inko table to update delete archivng chesthunnara?

read about archiving and archiving tables