QRY: Update CredentialID (Submitted as Request to Delete Credential)

Created by Kevin Schmidt - HCPro, Modified on Thu, 9 Oct at 3:11 AM by Kevin Schmidt - HCPro

Declare @OLDID int = 246908

Declare @NewID int = 219663

Update ClassRegistration

Set AHIMACredentialID__c = @NewID where AHIMACredentialID__c= @OldID

--Delete from CEUSplit__c where CredentialCycleID=649676

Open the old credential and get the credential cycle that are associated with the one you are to delete and then delete all CEU splits assigned to it.