Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Delete Script help

Author  Topic 

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: InsuranceCarriers
Fields 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,
LastModifiedBy

I need to delete all entries created by wquinones on 07/17/07

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-07-17 : 12:53:43
What have you tried so far?

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-07-18 : 04:04:42
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -