From DBI:

Portable applications should not assume that a new statement can be prepared and/or executed while still fetching results from a previous statement.

I don't know about SQL Server 2008, but based on your result, it seems it is one of those that does not support this. I never do this myself.

You might be able to use multiple database handles.

You could read all the table details into an array then iterate over the array, so that you have only one active statement at a time.