JeffS23
Posting Yak Master
212 Posts |
Posted - 2007-07-17 : 12:48:32
|
I need assistance with a delete script. What I need to do is delete all entrys created by a specific user on a specific date. My table Name: InsuranceCarriersFields under this table: InsuranceCarriersId, MasterInsuranceCarriersId, Inactive, [Name], ListName, Address1, Address2, City, State, Zip, Country, Contact, Phone1, Phone1Type, Phone2, Phone2Type, InsuranceGroupId, CollectionsGroupMId, CarrierTypeMId, FinancialClassMId, AllocationSetId, FilingMethodMId, FilingType, TransactionColumnSetId, PolicyTypeMId, CopayAmt, Deductible, GroupId, GroupName, MediGapId, OrgId, IncludeClaimOfficeNo, LocationId, PPOId, ECSClearinghouseId, ECSPayorId, ECSClaimOfficeNumber, ECSNEIC, UseRenderingProviderId, RequiresPIN, ECSMaximumNumberOfProcedures, ELIMIKDestination, ELIClearinghouseId, ELIPayorId, ELIMessageType, ElectronicFilingStatus, SupplementalFiling, Ledger, Notes, AlertNotes, RequiresAuth, ReferenceCarrier, PayerIdNumberCodeMId, OtherPayerIdNumber, SubscriberIDMask, AcceptAssignmentMId, DotId, PartnerInsuranceCarriersId, Created, CreatedBy, LastModified, LastModifiedByI need to delete all entries created by wquinones on 07/17/07 |
|