30 lines
878 B
MySQL
30 lines
878 B
MySQL
|
|
|||
|
|
-- <20><><EFBFBD><EFBFBD><EFBFBD>洢<EFBFBD><E6B4A2><EFBFBD><EFBFBD><EFBFBD>Ƿ<EFBFBD><C7B7><EFBFBD><EFBFBD>ڣ<EFBFBD><DAA3><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɾ<EFBFBD><C9BE>
|
|||
|
|
IF OBJECT_ID('dbo.[PR_NDXSHKHZB_yuyubo]', 'P') IS NOT NULL
|
|||
|
|
BEGIN
|
|||
|
|
DROP PROCEDURE dbo.PR_NDXSHKHZB_yuyubo;
|
|||
|
|
PRINT '<EFBFBD>洢<EFBFBD><EFBFBD><EFBFBD><EFBFBD> dbo.[PR_NDXSHKHZB_yuyubo] <20><>ɾ<EFBFBD><C9BE>';
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
-- <20><><EFBFBD><EFBFBD><EFBFBD>µĴ洢<C4B4><E6B4A2><EFBFBD><EFBFBD>
|
|||
|
|
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.*
|
|||
|
|
--,'<EFBFBD>麣<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>'='<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>'+'<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>'
|
|||
|
|
--,'<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ϼƽ<EFBFBD><EFBFBD><EFBFBD>'='<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>'+'<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>'+'<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>'+'<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>'+'<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<2D><><EFBFBD><EFBFBD>ҵ<EFBFBD><D2B5>'+'<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<2D><><EFBFBD>궩<EFBFBD><EAB6A9><EFBFBD><EFBFBD><EFBFBD><EFBFBD>'+'̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>'+'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>'+'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>'
|
|||
|
|
-- ,ROW_NUMBER() OVER (ORDER BY '<27><><EFBFBD><EFBFBD>ԱID') AS FID
|
|||
|
|
-- ,ROW_NUMBER() OVER (ORDER BY '<27><><EFBFBD><EFBFBD>ԱID') AS FIDENTITYID
|
|||
|
|
-- into #temp11
|
|||
|
|
--FROM (
|
|||
|
|
--SELECT DISTINCT
|
|||
|
|
--A.*
|
|||
|
|
|
|||
|
|
END
|