Hi All,

I need an advise. I'm writing a stored procedure in SQL2000 that will be used in overnight process to re-create sales table based on couple of tables from another database.

My question is : Is it better to issue a Truncate table statement to empty out the existing table or drop it and re-create it ? Is there an advantage or disadvantage of using either method ?

Thank you,
Daniel