Database

mr_lasseter wrote:

select value, min_date, max_date
from
(select value, min(date) min_date
from table
group by value) a,
(select value, max(date) max_date
from table
group by value) b
where a.value = b.value

Mike Lasseter

Stock        Period                    Amount   Tenor Fee (%) CCY Charge
  Stock001    1 Nov 2006 - 23 Nov 2006 100.000     22    0.03 USD     30
             23 Nov 2006 - 25 Nov 2006 200.000      2    0.03 USD     60
             25 Nov 2006 - 30 Nov 2006 100.000      5    0.03 USD     30
                                              SubTotal:     USD    120

bayangan1 wrote:

Actually there are 3 primary keys on the original table

tino00 wrote:

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

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 />