I have a huge table called "Clientdata" in a database called "Accounts" against which I have to run current month queries. Not only does this kill the box it runs on, but slows down everything in sight.
What I would like to do is export only the current month records from this database\table to another database\table (Statements\Clientdata) by means of a stored proc.
How do I setup the store proc as I have not done one yet ?
Thanksy dont u use a DTS package?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment