摘要：
if object_id('tempdb..#xs') is not nulldrop table #xs; create table #xs(vip varchar(20), date datetime, sale float)insert into #xs(vip, date, sale)select 'A' as vip,'2013-1-1' as date, 230 as sale union allselect 'A','2013-1-5', 400 union allselect 'A' 阅读全文