1)actually i want to transfer some data of these table to a different database.
2)after that i want to delete data from these tables, but each table shud have at least one month data.
1) The T-SQL query which will insert the requisite data into the other database
2) A delete statement which will delete the copied data from the source
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga