Hugo, there is another issue. DemoTableKey is the PRIMARY KEY of that table, so it must be unique. But what does one put in there (you are not specifying that) ;-). I ended up splitting it into an INT (IDENTITY) and a CHAR(6) when I ran the script.

And despite having to run the script instead of doing the calculations I learned something from the question. I don't see why this type of question should be considered too much work by anyone. After all, when I don't know an answer to a QOtD off-hand, I need to go and consult BOL or some other source, which also takes time.