Yes most of the fields are in the PK.

At current I am going from a completely empty table.

The table is on a local drive.

The parameterized view has all the records.

The two functions I am testing is importing new data and purging the data.

Jason

>Jason,
>
>>13 fields, length 105.
>
>So most of the fields are in the PK?
>
>>TRying to update 7000 records.
>
>Out of how many records in the table? Is the table on the local drive or network?
>
>Does the parameterized view have the 7k records in it and you are updating all of them back to the original table? Or does the p-view have additional records that are not updating?