Ashok

How many rows of data do you have? The problem with the SCD, and your stored procedure approach, is that they process one row at a time, which can be bad for performance, especially on large data sets. I would recommend that you get all your data into a staging table and then apply the column rules one at a time to the whole of the data. If you post some sample data and an example of one or two of the rules, I'll show you what I mean.

John