One Place Product Documentation
HOWTO: Renumber OnePlaceLog AgentCodes
* Backup the database just in case
* Run something similar to the following example SQL:
UPDATE CallActivity
SET caTransferAgentCode = NewCode
FROM CallActivity, tmpLookupAgent
WHERE caTransferAgentCode = oldcode and caClientcode='cbdfw'
Update CallDetailActivity
SET cdaFKValue = NewCode
FROM CallDetailActivity, tmpLookupAgent
WHERE cdaFKValue = oldcode and cdaClientcode='cbdfw' and cdaFK = 'agtAgentCode'
UPDATE CallPropertyActivity
SET cpaAgentCode = NewCode
FROM CallPropertyActivity, tmpLookupAgent
WHERE cpaAgentCode = oldcode and cpaClientcode='cbdfw'
* Remove the database backup after a week or so.
|
