Hi,

You mean to say abt the Dynamic tables.Considering sql server 7.0 there we are using the temporary tables this will be saved in the tempdb.But in sql server 2000 there is a data type called table.This is more efficient than using the temp table.tyr this