Thank-you! This worked perfectly! I didn't realize you could use your suggested syntax for the insert statement. This is exactly what I was looking for!
Thanks for the great ideas! I like the temporary table method but after I have the data in the temporary table I still need to extract it from the temp table in...