SELECT M.NAME,M.ALLNUM,N,OK FROM (SELECT G.NAME,COUNT(*) AS ALLNUM
FROM(SELECT F.NAME,F.CONTENT
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F) G GROUP BY G.NAME) M
LEFT JOIN
SELECT * FROM (SELECT H.NAME,COUNT(*) AS OK FROM( SELECT F.NAME,F.CONTENT
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F WHERE F.CONTENT LIKE '%签约%') H GROUP BY H.NAME) N
ON M.NAME=N.NAME 错误代码:
消息 156,级别 15,状态 1,第 7 行
在关键字 'SELECT' 附近有语法错误。
消息 156,级别 15,状态 1,第 11 行
在关键字 'ON' 附近有语法错误。
FROM(SELECT F.NAME,F.CONTENT
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F) G GROUP BY G.NAME) M
LEFT JOIN
SELECT * FROM (SELECT H.NAME,COUNT(*) AS OK FROM( SELECT F.NAME,F.CONTENT
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F WHERE F.CONTENT LIKE '%签约%') H GROUP BY H.NAME) N
ON M.NAME=N.NAME 错误代码:
消息 156,级别 15,状态 1,第 7 行
在关键字 'SELECT' 附近有语法错误。
消息 156,级别 15,状态 1,第 11 行
在关键字 'ON' 附近有语法错误。
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F WHERE F.CONTENT LIKE '%签约%') H GROUP BY H.NAME) N
ON M.NAME=N.NAME
SELECT M.NAME,M.ALLNUM,n,OK FROM (SELECT G.NAME,COUNT(*) AS ALLNUM
FROM(SELECT F.NAME,F.CONTENT
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F) G GROUP BY G.NAME) M
LEFT JOIN
( ----加
SELECT * FROM (SELECT H.NAME,COUNT(*) AS OK FROM( SELECT F.NAME,F.CONTENT
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F WHERE F.CONTENT LIKE '%签约%') H GROUP BY H.NAME) N
)t ----加
ON M.NAME=t.NAME
FROM(SELECT F.NAME,F.CONTENT
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F) G GROUP BY G.NAME) M
LEFT JOIN
(SELECT * FROM (SELECT H.NAME,COUNT(*) AS OK FROM( SELECT F.NAME,F.CONTENT
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F WHERE F.CONTENT LIKE '%签约%') H GROUP BY H.NAME)N)t
ON M.NAME=t.NAME
M.NAME,M.ALLNUM,N,OK
FROM
(SELECT G.NAME,COUNT(*) AS ALLNUM
FROM
(SELECT F.NAME,F.CONTENT
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F) G GROUP BY G.NAME) M
LEFT JOIN
(SELECT * FROM (SELECT H.NAME,COUNT(*) AS OK FROM( SELECT F.NAME,F.CONTENT
FROM (SELECT *
FROM (SELECT RIGHT(REGPERSON,LEN(REGPERSON)-CHARINDEX('.',REGPERSON)) AS NAME,CONTRACTID AS ID
FROM Contract WHERE RegDate BETWEEN '2008-01-01' AND '2008-01-31') B LEFT JOIN ContractFollow C ON B.ID=C.CONTRACTID) F WHERE F.CONTENT LIKE '%签约%') H GROUP BY H.NAME)N)t
ON M.NAME=t.NAME