rolinoberto (3/6/2015)
suppose I have an application, which is used to fill and use the information stored in a database, suppose (after a couple of months/later on) I add a new record into the tbtab1, which action need to be followed by adding the new row as a new column into the tbtab2.
And what is going to happen if in a few years there are hundreds or thousands of rows that would need to be made into columns? I would think again about this design if I were you. You could be setting someone up for some major headaches in the future. Unless, of course, your business rules dictate there will never be more than a few rows needing to be transposed. But then again, those rules might change after you've moved on. Just my two cents.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.