Answer Posted / sumit

I have The Same Problem And I Have Done Woth This


DECLARE @empid int, @empname varchar(50),@Cnt int

DECLARE duplicate_cursor CURSOR FOR

-- select all columns in table bit you must have an count column
select empid,empname, count(*) Cnt
from tbl_Temp
group by empid, empname
Having count(*) > 1

OPEN duplicate_cursor

FETCH NEXT FROM duplicate_cursor
INTO @empid, @empname,@Cnt

WHILE @@FETCH_STATUS = 0
BEGIN

SET @Cnt = @Cnt - 1

SET ROWCOUNT @Cnt

DELETE tbl_Temp
WHERE @empid = empid AND @empname = empname


FETCH NEXT FROM duplicate_cursor
INTO @empid, @empname
END

CLOSE duplicate_cursor
DEALLOCATE duplicate_cursor

-- dont forget to set rowcount to 0
SET ROWCOUNT 0

How to delete multiple rows with one delete statement in ms sql server?

1073

---

Why the trigger fires multiple times in single login?

1280

---

What is a DBMS, query, SQL?

1093

---

What security features are available for stored procedure?

1077

---

How to create a simple stored procedure in ms sql server?

1086

---

What are transactions in sql?

1136

---

What were the latest updates to SQL Azure service?

113

---

How many databases instances are there in sql server 2000?

1166

---

What are the properties and different types of sub-queries?

1050

---

Can we insert data into a view?

1194

---

Why should you use or avoid select * statements?

1071

---

What is the difference between functions and stored procedures?

1222

---

How do I setup a sql server database?

1129

---

What is the stuff?

1059

---

what is the sql equivaent of the dataset relation object ?

2068

---