Let say I have a database in Sql Server with about 20 tables in it, and that most of those tables have a field "qty".

How could I write query that says

" For each table in the database where the table has a column named 'qty'
Select table_name, Max(qty) as max_qty "



Basically, I need a cursor that shows the tablename and the Max(qty) from that table.

BTW it doesn't matter to me whether this is code I from FoxPro or in Sql Server Mgmt Studio.