ColdFusion & MSSQL : how to insert multiple rows with one unique id in one submission?

Another simple approach for inserting multiple records is an INSERT .. SELECT . (It is also mentioned in the link banyr posted). Because the skill id's are stored in another table, you can use an IN clause to SELECT them.

Then insert those values directly into your other table studenSkill with a simple query, no looping.

You should be able to use the following syntax, assuming you're on SQL server 2008.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.