Hi Christian,

I agree with you, it is very difficult to figure out from such a design but my problem is changing design of these table will impact my application. Is it possible to this by Procedural approach. If we write a Stored Procedure and Schedule that Stored Procedure daily at a certain time.

Thanks,

Debajit