Here's one thing that I constantly want to do. I have a lookup table of some sort that needs to be moved to another database, but the data may need to be massaged somewhat before moving it around. Plus I may want to store it in plain text format for versioning etc.
To this point I've been too lazy to implement it but I found a SQL guru (he must be if he went throught the trouble to write this) that has implemented just what I need.
I've used it this morning already and I'm quite happy.
Generate SQL statements from existing data in a table