I am presently using SQL Server 7.0, within WorkGroup Administrator application and using Database Manager.
What I have is a table of duplicate data, consisting of customers and leads. This may be of last record created against first record created, consisting of the same company.
Using the merge function, it merges the last record created with the first record created. For eg it deletes the lead, carrying over any attachments to customer.
What I need is the data from fields within lead, to be carried over as well. But, at the moment the merge function is deleting these fields.
Is there any way, I can carry this data over. I have created a temporary table, with the required data from specific fields that I need.
Could anyone help ASAP.
What I have is a table of duplicate data, consisting of customers and leads. This may be of last record created against first record created, consisting of the same company.
Using the merge function, it merges the last record created with the first record created. For eg it deletes the lead, carrying over any attachments to customer.
What I need is the data from fields within lead, to be carried over as well. But, at the moment the merge function is deleting these fields.
Is there any way, I can carry this data over. I have created a temporary table, with the required data from specific fields that I need.
Could anyone help ASAP.
