--> 测试数据: @T
declare @T table (name varchar(5),houdu numeric(2,1),kuandu int,changdu int)
insert into @T
select '木板1',0.7,850,1000 union all
select '木板2',0.7,850,1200 union all
select '木板3',0.7,950,2000 union all
select '木板4',0.7,1100,750 union all
select '木板5',0.7,600,1100

--变量自行设定
declare @houdu numeric(2,1) set @houdu=0.7
declare @kuandu int set @kuandu=900 
declare @changdu int set @changdu=1050
--查询
select top 1 * from @T
where  houdu>=@houdu and kuandu>=@kuandu and changdu>=@changdu
order by houdu,kuandu,changdu
--结果
/*
name  houdu                                   kuandu      changdu
----- --------------------------------------- ----------- -----------
木板3   0.7                                     950         2000
*/

------解决方案--------------------


[/code]
--> 测试数据：tbl
go
if object_id('tbl') is not null  
drop table [tbl]
go
create table [tbl](
name varchar(5),
houdu numeric(2,1),
kuandu int,
changdu int
)
insert tbl
select '木板1',0.7,850,1000 union all
select '木板2',0.7,850,1200 union all
select '木板3',0.7,950,2000 union all
select '木板4',0.7,1100,750 union all
select '木板5',0.7,600,1100 union all
select '木板1',0.6,850,1000 union all
select '木板2',0.6,850,1200 union all
select '木板3',0.6,950,2000 union all
select '木板4',0.6,1100,750

declare @houdu numeric(2,1)
set @houdu=0.7
declare @kuandu int
declare @changdu int
select @kuandu=830,@changdu=1100
create table #t(
id int identity(1,1),
name varchar(5),
houdu numeric(2,1),
kuandu int,
changdu int,
kuanducha int,
changducha int
)
insert #t
select name,houdu,kuandu,
changdu,kuandu-@kuandu,changdu-@changdu from tbl
where houdu=@houdu and kuandu>@kuandu
and changdu>@changdu  
order by kuandu-@kuandu,changdu-@changdu asc

select top 1 name,houdu,kuandu,changdu from #t  


name	houdu	kuandu	changdu
木板2	0.7	850	1200
[/code]