SQL Server Performance Forum – Threads Archive

history

i need to keep history of each Listing/Property ID and it’s price changes. what are the options to accomplisth this? trigger, etc…

???? How do you have it stored now? Active Flag/datetime
end date/start date
trigger with history table
stored procedure logic
archive process blah, blah, blah Million ways to skin the cat kind of thing. You need to be more specific. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

no history kept currently.
so when a properties price changes, we just store that price.

Well, the least amount of work would probably be a history table with a trigger. Depending on how you want to use it though, it might not be the right answer. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

Why not keep the historic data in seperate table for record purpose, with the help of Trigger… inserted… deleted tables. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>