I have a table which contains house details called property. I am creating a localised application, and I have a db table called propertylocalised. In this table is held duplicates of the data and culture column e.g.

key  culture propertyname

1     en       helloproperty

1     fr       bonjourproperty

At the moment I have all my en culture inserted but I want to duplicate all of those rows and then for every other row insert fr into culture.

I obviously only want to do this once, for the purpose of setting up the localisation.

Thanks

Andy