[易飞]主营业务分析

SQL代码：

USE [ZE]
GO
/****** Object:  StoredProcedure [dbo].[UP_MainBusiness]    Script Date: 04/11/2012 11:01:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--============================================================
--用途:主营业务分析表
--作者:龚德辉
--日期:2012-04-10
--============================================================

Create PROCEDURE [dbo].[UP_MainBusiness]

AS
BEGIN
/*主营业业务收入*/
create table #mainbusiness 
(
   item nvarchar(20)
  ,s