Can be done using temp table

SELECT EmpID,EmpName INTO #temp

FROM Employees

GROUP BY EmpID,EmpName

HAVING COUNT(*)>1

DELETE Employees FROM Employees a INNER JOIN #temp b ON

a.EmpID=b.EmpID

INSERT INTO Employees(EmpID,EmpName)

SELECT EmpID,EmpName FROM #temp

Could you please send sample data set. It works fine with merge join.

solved thanks

Thanks a lot as simple as that. really appreciate

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message

OnPostValidate,PRAVEEN,PRAVEEN\HomeComputer,File System Task,{F8E35F86-6F14-4FBC-B43E-0DC84E644849},{53E5E464-3383-47F5-97B7-014D12224E8F},2/22/2011 8:20:40 PM,2/22/2011 8:20:40 PM,0,0x,(null)

OnPostValidate,PRAVEEN,PRAVEEN\HomeComputer,Package1,{12F1584C-3E98-4398-9964-764F8DF3439A},{53E5E464-3383-47F5-97B7-014D12224E8F},2/22/2011 8:20:40 PM,2/22/2011 8:20:40 PM,0,0x,(null)

OnPostValidate,PRAVEEN,PRAVEEN\HomeComputer,File System Task,{F8E35F86-6F14-4FBC-B43E-0DC84E644849},{2D502555-864C-41B2-94D1-FE2729CA092E},2/22/2011 8:20:40 PM,2/22/2011 8:20:40 PM,0,0x,(null)

OnPostValidate,PRAVEEN,PRAVEEN\HomeComputer,Package1,{12F1584C-3E98-4398-9964-764F8DF3439A},{2D502555-864C-41B2-94D1-FE2729CA092E},2/22/2011 8:20:40 PM,2/22/2011 8:20:40 PM,0,0x,(null)

PackageStart,PRAVEEN,PRAVEEN\HomeComputer,Package1,{12F1584C-3E98-4398-9964-764F8DF3439A},{2D502555-864C-41B2-94D1-FE2729CA092E},2/22/2011 8:20:40 PM,2/22/2011 8:20:40 PM,0,0x,Beginning of package execution.

OnPreExecute,PRAVEEN,PRAVEEN\HomeComputer,Package1,{12F1584C-3E98-4398-9964-764F8DF3439A},{2D502555-864C-41B2-94D1-FE2729CA092E},2/22/2011 8:20:40...

as simple as that

it worked

thanks

praveen

Hi

i am not able solve this problem. can any body guide how to solve this. send me sample script.

thanks

sure going forward will make sure that

thanks

thanks for the inputs

IF you could send me sample script would appreciate that.(cascade delete)

the script

DECLARE @DeleteOutput3 TABLE (CONID INT PRIMARY KEY CLUSTERED)

DELETE Contact

OUTPUT

deleted.CONTACTID

INTO @DeleteOutput3

WHERE CONTACTID = 10;

DELETE SALESHEADER FROM SalesHeader INNER JOIN

@DeleteOutput3 d ON SalesHeader.CONTACTID=d.CONID

Hey i just checked with this query given by you

still i am getting error message. Could you please help me to resolve this issue

Msg 547, Level 16, State 0,...

YES I WANT TO DELETE OR UPDATE ROWS FROM TABLE 2 ALSO

THANKS

🙂

HEY

COULD YOU PLEASE SHARE SAMPLE SAMPLE CODE.

THANKS