_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › 襷れ殊豐覿壱手讌一危磯ゼ豌襴る
|
|
豌襴 一危磯ゼ 襷れ 豌襴る,
語覿 語蟾讌朱 一危磯ゼ 覲伎 譴 . declare @yyyy char(4) , @mm char(2) set @yyyy = '2011' set @mm = '04' --螳 4 12 企朱.. ;with t as ( select convert(date, '2011-04-12') date_key union all select convert(date, '2011-03-01') date_key union all select convert(date, '2011-02-01') date_key ) select left(date_key,7) + case when convert(char(7), getdate()-1, 121) = @yyyy + '-' + @mm and left(date_key,7) = @yyyy + '-' + @mm then '(' + @yyyy + '-' + @mm + '-01 ~ ' + convert(char(10), getdate()-1, 121) + ')' else '' end from t order by 1 /* 2011-02 2011-03 2011-04(2011-04-01 ~ 2011-04-12) */
鏤
|
覓企Μ 豺 企朱 企ゼ 蟯危螻 苦 朱 蠏碁Μ螻 る 讌り 苦朱 企 覯企. (襴 豌伎ろ壱 れ 語 企蟆 伎錫 譴) |