这是我在数据库上运行的查询,但我发现以下3个错误一直发生。
我遇到了错误:
CREATE VIEW STUD1
AS
SELECT
*,
RN = ROW_NUMBER() OVER (PARTITION BY R.ContractID
ORDER BY CONVERT(DATE, LEFT(EVAL_PERIOD , charindex('-', EVAL_PERIOD) - 1), 103) DESC)
FROM
SCMD3.DBO.CPE R;
GO
CREATE VIEW STUD2
AS
SELECT
C.ContractID,
GRED1 = MAX(CASE WHEN RN = 2 THEN ALL_GRADE END),
MARK1 = MAX(CASE WHEN RN = 2 THEN ALL_SCORE END),
GRED2 = MAX(CASE WHEN RN = 1 THEN ALL_GRADE END),
MARK2 = MAX(CASE WHEN RN = 1 THEN ALL_SCORE END)
FROM
STUD1 C
GROUP BY
C.ContractID;
GO
SELECT
s.ContractTitle, x.GRED1, x.MARK1, x.GRED2, x.MARK2
FROM
STUD2 x
INNER JOIN
SCMD3.DBO.CONTRACTMASTER s ON x.ContractID = s.ID;
我遇到了错误:
我尝试了一些解决方案,但仍无法执行。非常感谢您的帮助。Msg 2714,级别16,状态3,过程STUD1,行2
数据库中已经存在名为“STUD1”的对象。Msg 2714,级别16,状态3,过程STUD2,行9
数据库中已经存在名为“STUD2”的对象。Msg 537,级别16,状态2,行20
向LEFT或SUBSTRING函数传递的长度参数无效。