Why in the world would you insert data already existing in tables into yet another table? Judging from your requirement, you are not changing the data in any way, simply gathering it. So why have data in two places? If you do, you're headed for un-reliability-ville. imho If you REALLY need to create TEMP data for performance or whatever, make sure it is in a stored procedure and not application logic. ; ) .randy --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss