Answer Posted / shankar

First Of All Create Table
create table EMP(empid int, ename varchar(10),sal int,
deptid int)

insert into EMP values(11, 'Ram', 10000, 10)
insert into EMP values(11, 'Ram',10000,10)
insert into EMP values(22, 'Raj', 20000, 20)
insert into EMP values(22, 'Raj', 20000, 20)
insert into EMP values(33, 'Anil', 15000, 30)
insert into EMP values(33, 'Anil', 15000, 30)
insert into EMP values(44,'bbb',11111,40)
--Now Run This query It works
Declare @empID int, @RecCount int,@Name varchar (10),@Sal
int, @deptid int
SET @RecCount = 0
Declare MyCur Cursor for
Select empid,ename Sal,DeptID,Count(ID)-1 as Records from
EMP Group BY empid,ename Sal,DeptID having Count(empid)>1
Open MyCur
Fetch FROM MyCur INTO @empID,@Name,@sal,@DeptID,@RecCount

WHILE @@FETCH_STATUS = 0
BEGIN
SET ROWCOUNT @RecCount

DELETE from EMP where empID= @empID
SET @empID= 0
SET @Name = ''
SET @Sal= 0
SET @DeptID = 0
SET @RecCount = 0
SET ROWCOUNT 0
Fetch FROM MyCur INTO @empID,@Name,@sal,@DeptID,@RecCount
END

Close MyCur
DEallocate MyCur

what is memory-optimized nonclustered indexes

1064

---

What are parameterized reports?

204

---

How to assign null values to variables or columns?

1027

---

Can we insert data into a view?

1194

---

What are the new data types are introduced in sql 2000?

949

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1167

---

How to include date and time values in sql statements?

1142

---

How would you choose between a clustered and a non-clustered index?

1019

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1202

---

Which trace flags are enabled in sql server?

1076

---

What does asynchronous call backs means?

1232

---

Which Model uses the SET concept

1042

---

What is the stuff and how does it differ from the replace function?

1227

---

What are the advantages of using third-party tools?

1037

---

How will you optimize a stored procedure optimization?

1116

---