Answer Posted / mohit d jethva

///////////Cursor for delete duplicate record in
table//////////

DECLARE @ID int
DECLARE @NAME NVARCHAR(50)
DECLARE @COUNT int

DECLARE CUR_DELETE CURSOR FOR
SELECT [ID],[NAME],COUNT([ID]) FROM [Example] GROUP BY [ID],
[NAME] HAVING COUNT([ID]) > 1

OPEN CUR_DELETE

FETCH NEXT FROM CUR_DELETE INTO @ID,@NAME,@COUNT
/* Loop through cursor for remaining ID */
WHILE @@FETCH_STATUS = 0
BEGIN

DELETE TOP(@COUNT -1) FROM [Example] WHERE ID = @ID

FETCH NEXT FROM CUR_DELETE INTO @ID,@NAME,@COUNT
END

CLOSE CUR_DELETE
DEALLOCATE CUR_DELETE

Mohit D Jethva

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

954

---

What is database replication? What are the different types of replication you can set up in sql server?

1017

---

Mention the 3 ways to get a count of the number of records in a table.

1025

---

Why SQL Agent is used?

1204

---

Can we create clustered index on composite key?

1171

---

What is the recommended total size of your memory optimized tables?

1006

---

What are the different normalization forms?

1164

---

What is data modeling and Reterminal integrity?

2013

---

what are the reporting service components in SSRS?

170

---

What security features are available for stored procedure?

1080

---

What is attribute? : sql server analysis services, ssas

1069

---

How to insert a new row into a table with "insert into" statements in ms sql server?

1016

---

What are sub reports?

208

---

How to execute function in stored procedure sql server?

1236

---

What is the osql utility?

1038

---