Home Forums SQL Server 7,2000 T-SQL variable tablename in cursor select stmt RE: variable tablename in cursor select stmt

  • The number of tables are about 150 now and the number of rows anywhere from 0 to a million in each table. The number of tables and rows can increase in future as they get updated once a week/2 weeks. The table name has to be obtained dynamically since the it put together as tblFilenames_XY based on X and Y fields that I can get that from tblLandRec_Index_Series and another table taht has similar info. From each table tblFilenames_XY, I need only 1-5 rows of data required for calculating statistics that I would put into a temp table . These would be eventually displayed using ACCESS (hopefully !). Would these nested cursors degrade the performance severely ?