declare @tb table(fid int,hid int,sid int,td1 int,td2 int,td3 int,td4 int)
insert into @tb select 1,2,4,11,22,null,null
insert into @tb select 1,2,5,null,null,33,44

select fid,hid,
isnull(max(td1),min(td1)) as td1,
isnull(max(td2),min(td2)) as td2,
isnull(max(td3),min(td3)) as td3,
isnull(max(td4),min(td4)) as td4
from @tb 
group by fid,hid

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

SQL code
DECLARE @t TABLE(fid int,hid int,sid int,td1 int,td2 int,td3 int,td4 int)
INSERT @t SELECT 1,    2 , 4,    11  ,  22 , null,  null 
UNION ALL SELECT 1 ,   2,  5 ,   null , null,  33 ,   44 
UNION ALL SELECT 1,    2,  1,     24,null,null,null
UNION ALL SELECT 2,    1, null,2,1,1,1

SELECT fid,hid,(SELECT TOP 1 td1 FROM @t WHERE fid=a.fid AND hid=a.hid AND td1 IS NOT NULL) td1 /*td2,td3,td4类同*/ FROM @t a
GROUP BY fid,hid