Database

delete mytesttable from 
(select id, minSerial 
	from (select count(*) as total,id, 
		(select min(serialnumber)  
				from mytesttable tInside 
				where tInside.id = t.id) as MinSerial
			from mytesttable t group by id)  as tbl 
	where total=2) as tbl
where mytesttable.id = tbl.id and mytesttable.serialnumber=tbl.minserial

<br />
<br />
string connStr;<br />
<br />
string Driver = "Driver={SQL Server};";<br />
string Database = "Database=db_name;";<br />
string connectionType = "Trusted_Connection=yes;";<br />
<br />
connStr = Driver + Database + connectionTypel<br />
<br />

SELECT CONVERT(DECIMAL (18,2),ROUND(deccolumn,2)) AS deccolumn FROM mytesttable

declare @foo decimal(18, 6)<br />
set @foo = 123.45678<br />
select cast(@foo as decimal(18, 2))

alexrad wrote:

I'M SORRY FOR NOT TELLING ALL DETAILS