Dynamic SQL INSERT Generator Unleashed!
Mark Clerget has another excellent post on using SQL to generate SQL. This time Mark demonstrates how to generate a series of INSERT statements from an arbitrary table.
So you are probably saying, "Great, so you can generate a CREATE TABLE statement...Whoopee!". Well, if I could help you fill that table or tables using a script that dynamically generates INSERT statements based on the contents of a table, would that be worth something to you? Great! Read further and lets really impress those SQL jockey friends of yours. [Mark Clerget's Blog]