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
)

Your table has a large character field there are queries that use this field in their search clause what should you do?

850

---

How fixed length strings are truncated and padded?

939

---

Why do we partition data?

974

---

What is the purpose of self join?

913

---

Explain system functions or built-in functions? What are different types of system functions?

915

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

899

---

How do I edit a stored procedure in sql server?

880

---

What is row_number function?

940

---

What causes index fragmentation?

933

---

What is the benefit of normalization?

1018

---

How to drop existing indexes in ms sql server?

1013

---

How are the exceptions handled in sql server programming?

996

---

Explain what is the main purpose of having conversation group?

878

---

what method you can use to reduce the overhead of Reporting Services data sources?

233

---

How many levels of sp nesting are possible?

957

---