I have a bunch of data that is stored in a few tables and serves as a template when a new customer or such is created.
I know i could do a select and copy all the properties and execute a save, however some of the fields are large retrieving to and from the db doesn't seem the most optimal idea.
I have also thought about writing a custom insert select sql that will just copy from one table to another.
thoughts?