魏宇

导航

 

2017年7月31日

摘要: SELECT tempcodedesc AS '項目',SMT01 AS '1月SMT',AP01 AS '1月AP',SUM01 AS '1月Total',SMT02 AS '2月SMT',AP02 AS '2月AP',SUM02 AS '2月Total',SMT03 AS '3月SMT',AP0 阅读全文
posted @ 2017-07-31 10:43 魏宇 阅读(227) 评论(0) 推荐(0)
 
摘要: if object_id('tempdb..#temp1') is not null drop table #temp1 if object_id('tempdb..#temp2') is not null drop table #temp2 select a.ClientNo, a.YYMonth 阅读全文
posted @ 2017-07-31 10:41 魏宇 阅读(178) 评论(0) 推荐(0)