history | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.