sql server 临时表使用
1 DROP TABLE ##tablename -- 查询前先删除
2 SELECT * INTO ##tablename FROM ( --创建表,第一次插入数据
3 SELECT s.CreateDt ,m.TYPE, m.Pid,c.Pro_FullName,c.Pro_Id,m.UnitId,b.Pro_Num,b.Price,b.Remark,b.FullPrice FROM SellList s,
4 SellDetail b,
5 ProductDetail c ,
6 MonthlyStatement m
7 WHERE s.Id=b.SellId
8 AND c.Id=b.Pro_Id
9 AND s.SellId = m.Pid
10 AND m.Pid LIKE 'xsd%'
11 ) AS table1
12 INSERT INTO ##tablename --第二次插入数据
13 SELECT s.CreateDt,m.TYPE, m.Pid,c.Pro_FullName,c.Pro_Id,m.UnitId,b.Pro_Num,b.Price,b.Remark,b.FullPrice FROM SellList s,
14 SellDetail b,
15 ProductDetail c ,
16 MonthlyStatement m
17 WHERE s.Id=b.SellId
18 AND c.Id=b.Pro_Id
19 AND s.SellId = m.Pid
20 AND m.Pid LIKE 'xsd%'
21 --查询临时表
22 SELECT * FROM ##tablename WHERE 1>0 ORDER BY UnitId
23 GO
2 SELECT * INTO ##tablename FROM ( --创建表,第一次插入数据
3 SELECT s.CreateDt ,m.TYPE, m.Pid,c.Pro_FullName,c.Pro_Id,m.UnitId,b.Pro_Num,b.Price,b.Remark,b.FullPrice FROM SellList s,
4 SellDetail b,
5 ProductDetail c ,
6 MonthlyStatement m
7 WHERE s.Id=b.SellId
8 AND c.Id=b.Pro_Id
9 AND s.SellId = m.Pid
10 AND m.Pid LIKE 'xsd%'
11 ) AS table1
12 INSERT INTO ##tablename --第二次插入数据
13 SELECT s.CreateDt,m.TYPE, m.Pid,c.Pro_FullName,c.Pro_Id,m.UnitId,b.Pro_Num,b.Price,b.Remark,b.FullPrice FROM SellList s,
14 SellDetail b,
15 ProductDetail c ,
16 MonthlyStatement m
17 WHERE s.Id=b.SellId
18 AND c.Id=b.Pro_Id
19 AND s.SellId = m.Pid
20 AND m.Pid LIKE 'xsd%'
21 --查询临时表
22 SELECT * FROM ##tablename WHERE 1>0 ORDER BY UnitId
23 GO
