Hi Lynn
Very rightly pointed out that my table is actually a heap, without clustered index (I should have been more specific earlier). Just to add on, the transaction table does not have date field. So partitioning (implementing sliding window partition) is not feasible.
Kindly suggest some better method.
One more thing, I am not very sure if SQL server allows bulk insert (using "BULK INSERT" keyword) from one table to another? Definitely this feature is available when importing data from a flat file (and other variants) to a table.
I really appreciate your help on this.
Thank you.
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter