Answer Posted / sameer

--select * from #TempR
select * into #temp2 from #TempR

-- select * from #temp2

alter table #temp2 add record_id numeric(5,0) identity not
null

/* select those row which are repeated */

select * into #qwe
from #temp2
where exists(

select null from #temp2 b
where b.ID = #temp2.ID
and b.TYPE = #temp2.TYPE
group by b.ID, b.TYPE
having
count (*) >=2
)

--select * from #qwe




/* delete those row which are repeted */

delete from #TempR where ID in ( select ID from #qwe)

/* insert those row which are deleted */

delete from #qwe where record_id not in (

select record_id
from #qwe
group by ID, TYPE
having record_id = max (record_id)
)

-- select * from #qwe
alter table #qwe drop record_id

insert into #TempR
select * from #qwe

/* see output */


select * from #TempR

/* check for row getting repeted */


select *
from #TempR
where exists(

select null from #TempR b
where b.ID = #TempR.ID
and b.TYPE = #TempR.TYPE
group by b.TT_ID, b.EQP_TYPE
having
count (*) >=2
)

What the different types of Replication and why are they used?

1072

---

Benefits of Stored Procedures?

976

---

How does stuff differ from the replace function?

1018

---

What is your recommendation for a query running very slow? : sql server database administration

1050

---

What is transaction server implicit?

1015

---

List the different types of joins?

1012

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1065

---

last function used in MS Access to convert sql what function will use in sql

2077

---

Tell me what is the significance of null value and why should we avoid permitting null values?

990

---

If a table does not have a unique index, can a cursor be opened on it?

915

---

How to create percentile function?

156

---

when would you go for denormalization? : Sql server database administration

874

---

What are drilldown reports?

156

---

How to select some specific rows from a table in ms sql server?

1010

---

Define inner join? Explain with an example?

1002

---