title: SQL Server 2008 How to create multiple tables for each record in a table?
body: <p>I have a table that contains consultant's first name, last name, skill name, and certification which basically shows if the consultant is certified in their skill.  I am trying to create a script that will generate a table for each consultant with two columns (skills, and certification status) some consultants may have more than one skill.  I am thinking about the while loop syntax or dynamic sql but have no luck.  I have searched the web thoroughly with no luck. </p>