• So here is the answer you did not expect: in a relational database a table is supposed to model a unique entity, and each column is supposed to model a unique attribute of that entity. Given this, the question you ask does not make much sense. Yes, it is possible to do, but it is not a good exercise for a beginner, because it will lead into paths where you should not wander at this point.

    My assumption is that you do this as some kind of exercise to learn, but it is not a good exercise where you are now.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]