日期:2014-05-17 浏览次数:20949 次
with tb(AMsection,PMsection) as(
select 4,3)
select '上午第'+convert(varchar,number)+'节' from master..spt_values a,tb
where type='p' and number>0 and number<=AMsection
union all
select '上午第'+convert(varchar,number)+'节' from master..spt_values a,tb
where type='p' and number>0 and number<=pMsection