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

whats the maximum size of view state??

2193

---

Explain the dirty pages?

1011

---

what is a sub-report?

140

---

Which table keeps the locking information?

931

---

Explain user defined functions?

996

---

What is the difference between varchar and nvarchar datatypes?

1090

---

How adventureworkslt tables are related?

931

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

1048

---

What is coalesce in sql server?

1056

---

How does recursive cte works in sql server?

1019

---

What are the properties of the relational tables?

881

---

What are types of storage modes? : sql server analysis services, ssas

1045

---

what is the main function of a query parameter?

152

---

What are the elements of dbms?

967

---

Write a SQL query to make a column as unique?

1043

---