 Re: Batch Coping
You could save the primary key of the copied rows into another table and use that as your
"delta".
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Guru S. Anand" <gurusanand@hotmail.com> wrote in message
news:0d0a01c29c01$e68f8160$8ef
82ecf@TK2MSFTNGXA04...
> Hi all
>
> I am having a MasterTable having log information.
> There is an Stored Procedure which runs periodically for
> evey 15 minutes and copy all the data from MasterTable to
> SummaryTable. The data copied from MasterTable to
> SummaryTable is not the duplicate of the MasterTable.
> Instead there will be some conversion of Data from
> MasterTable to SummaryTable.
> 1. For the First time I need to copy all data from
> MAsterTable To SummaryTable.
> 2. Then in every 15 minutes I should copy only the exta
> records inserted into MAsterTable to the SummaryTable. IS
> there any way to achieve this?
>
> Problem is : The Data copied from MAsterTable does'nt have
> any relation after formating and copied into SummaryTable.
>
> Any Global variable or any trick I hold the number of
> records copied from MAsterTable. Then after 15 minutes I
> can copy
> only the rest of the records....
> If so where Can I hold the number of records copied? Any
> suggestion
>
> Thanks,
> Anand
Report this post to a moderator
| 
12-05-02 02:23 AM
