At 07:58 PM 11/01/2012, Ahmet Nuri D wrote:

>Because tables should create automatically every year.
>I am planning now, I will create one template table and copy it every year automatically

That doesn't mean you have to do it with a stored procedure! Prepare a suite of scripts and run the appropriate one(s) as and when required.

./heLen