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