摘要:
USE [PM]GO/****** 对象: StoredProcedure [dbo].[LfangSatstics] 脚本日期: 08/24/2013 10:57:48 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:-- Create date: -- Description:-- =============================================ALTER PROCEDURE [dbo].[Lf 阅读全文
摘要:
--第一步:根据系统编号、列、单价分组求和select CLBH,DJ,sum(SL) as SL,sum(JE) as JE,Lie into #TempSZCMXfrom #ShouZhiCunMingXi group by Lie, CLBH , DJ order by Lie,CLBH--第二步:列转行,分组求和insert into #TempLastResultsSELECT YJ,EJ, MoJi=(CASE WHEN grouping(YJ) = 1 THEN '0' WHEN grouping(EJ) = 1 THEN [YJ] when grouping(M 阅读全文