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
)

Explain full-text query in sql server?

1054

---

What is the synonym of join?

1018

---

What do you do in data exploration

1050

---

what is a schema in sql server 2005? : Sql server database administration

1083

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1056

---

what is a transaction and what are acid properties? : Sql server database administration

1090

---

How to generate create view script on an existing view?

1045

---

How to perform backup for certificates in sql server? : sql server security

1145

---

What happens if date-only values are provided as date and time literals?

1078

---

Explain the concepts and capabilities of sql server?

1014

---

what is the sql equivaent of the dataset relation object ?

2070

---

What is an index in sql?

1069

---

What is b tree index?

968

---

How do you migrate data from mssql server to azure?

167

---

How many clustered indexes there can be on table ?

1073

---