Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 hi

Author  Topic 

sharmi23
Starting Member

1 Post

Posted - 2010-03-05 : 02:02:55
hi
we are archiving records in a table
the number of records inserted for archiving should match the number of records deleted
since we are copying th source table by inserting n creating a new one and deleting the original
for tracking we are creating a new table and counting it
how to write in plsql?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-05 : 09:54:23
for pl sql queries please post in oracle forums. this is MS SQL Server T-SQL forum

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-08 : 02:17:59
Post at www.orafaq.com

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -