2014年2月18日
SQLServer 添加字段分组去除重复项，用临时表
摘要： USE [DB] 2 GO 3 4 SELECT IDENTITY(INT,1,1) AS autoid 5 , a.* 6 INTO [dbo].[##temp0] 7 FROM (SELECT DISTINCT c.CustomerId AS CustomerId 8 ,t.TaxRule AS TaxRule 9 FROM [dbo].[T] t10 JOIN [dbo].[C] c11 ON t.OldCHId = c.OldCHId12 JOIN [dbo].[CU] u13 ON c.Custom... 阅读全文
posted @ 2014-02-18 14:24 Cyber9527 阅读(634) 评论(0) 推荐(0)