"gurvinder gill via SQLMonster.com" wrote:

> Hi
> I want to create a stored procedure.
> I have 2 tables called orders and orderdetail.Now i want to move orders
> from these tables in to new tables called orders2 and
> orderdetail2.Perticularly those orders which r there more than 60 day(means
> those orders which r 60 day old ,,to new tables) and removing them from
> older tables(first tables) that is orders and orderdetails.Please help me
> this is urgency.
>