I have a list of a 200 SalesPerson ID’s in a table (SalesIDs) that I want to insert into a new table. However, I want the new table to contain each ID 12 times—once for each month of the year. So the new table would look something like this:
ID1, 01, 2002
ID1, 02, 2002
ID1, 03, 2002
I can’t figure out what how to step through the SalesID table and create 12 new rows for each ID. Any clues would be appreciated.