BR><BR>Now the problem is I need a select statement that assigns a variable that also has a dynamic table name. Ex:<BR><BR>SELECT @SQL = 'SELECT @num_rows=COUNT(*) FROM ' + @data_table<BR>EXEC ...