rado

only remove duplicate records, select duplicated fields, and then apply group by create table #temp same schema INSERT INTO #temp SELECT field1,field2,field{n} FROM yourtable GROUP BY field1,field2,field{n} DELETE OLDdata INSERT INTO yourtable select * from #temp DROP #temp recommend: in transaction :)

i have table (id1,id2) 1.row [1,2] 2.row [2,1] 3.row [3,4] 4.row [4,3] 5.row [5,6] 6.row [6,5] i want to get result: 1.row [1,2] 3.row [3,4] 5.row [5,6] or 2.row [2,1] 4.row [4,3] 6.row [6,5] i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you …

I need to create connection pool i think shared connections and controlled through semaphores. or its only on connections string level? , i saw code in java but NET nothing.

i thing that is SET IDENTITY ON insert INTO tb (id,.....) values(1,...) SET IDENTITY OFF , then you can set ident same as previous data.