select f1='本月合同到期的人数', f2=cast(count(*) as varchar(10))+'人' from table where Month(合同到期日期)=Month(GetDate())
union all
select f1='今天合同到期的人数', f2=cast(count(*) as varchar(10))+'人' from table where 合同到期日期=GetDate()
select '本月合同到期的人数' as field1 ,count(*) as field2 from table where .......
union
select '今天合同到期的人数' as field1 ,count(*) as field2 from table where .......
'