-- 检查存储过程是否存在，存在则删除
IF OBJECT_ID('dbo.[PR_NDXSHKHZB_yuyubo]', 'P') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.PR_NDXSHKHZB_yuyubo;
    PRINT '存储过程 dbo.[PR_NDXSHKHZB_yuyubo] 已删除';
END
GO

-- 创建新的存储过程
CREATE PROCEDURE dbo.PR_NDXSHKHZB_yuyubo
  @FDate DATETIME  ,@CurrentOrgUnitId NVARCHAR(100) null,@salerId NVARCHAR(100) null

AS
BEGIN
  
  DECLARE @monthStart DATETIME,@monthEnd DATETIME,@yearStart DATETIME , @yearEnd DATETIME
 

--  SELECT EE.*
--,'珠海派诺业绩合计'='累计销售额'+'往年订单变更金额'
--,'派诺集团最终业绩合计金额'='累计销售额'+'往年订单变更金额'+'兴诺业绩'+'兴诺往年订单变更'+'武汉派诺-当年业绩'+'武汉派诺-往年订单变更'+'碳索业绩'+'香港派诺业绩'+'华夏云联业绩'
--  ,ROW_NUMBER() OVER (ORDER BY '销售员ID') AS FID
--  ,ROW_NUMBER() OVER (ORDER BY '销售员ID') AS FIDENTITYID 
-- into #temp11
--FROM (
--SELECT DISTINCT    
--A.*

END