I built this script for when I needed to move small data sets around, typically between servers. The script uses the tables columns to generate select statements of the actual data in the table.
2) Enter databse table, table name (note, this assumes DBO schema) and optional top percent
NOTE: Dont use this for large data sets. As with any statement, doing a union on large data sets performs horribly.