附近有语法错误
来源:互联网 发布:编程语言和编译器 编辑:程序博客网 时间:2024/04/27 10:53
SET @L_SQL2 = N'
SELECT DeptID, DeptName, AdminUserId, AdminUserName, AssignCount, TraceCount, UserIntention1, UserIntention2, UserIntention3, UserIntention4, UserIntention5, UserIntention6, UserIntention7
FROM (
SELECT
Z3.DeptId AS DeptID, Z6.DeptName AS DeptName,
Z3.AdminUserId AS AdminUserId, Z7.UserName AS AdminUserName,
Z4.AssignCount AS AssignCount,
Z5.TraceCount AS TraceCount,
Z3.UserIntention1 AS [UserIntention1],
Z3.UserIntention2 AS [UserIntention2],
Z3.UserIntention3 AS [UserIntention3],
Z3.UserIntention4 AS [UserIntention4],
Z3.UserIntention5 AS [UserIntention5],
Z3.UserIntention6 AS [UserIntention6],
Z3.UserIntention7 AS [UserIntention7]
FROM ' +
'##TempUserIntention AS Z3 ' + CHAR(13) +
' LEFT JOIN(
SELECT ZZ4.AssignCount, ZZ4.[AdminUserId]
FROM (
SELECT COUNT(DISTINCT [UserId]) AS AssignCount, [AdminUserId]
FROM [DbCRM].[dbo].[tblUserInfo]
GROUP BY [AdminUserId]
) AS ZZ4
) AS Z4 ON( Z4.[ADMINUSERID] = Z3.[ADMINUSERID])' + CHAR(13) +
' LEFT JOIN(
SELECT ZZ5.TraceCount, ZZ5.[AdminUserId]
FROM (
SELECT COUNT(DISTINCT [UserId]) AS TraceCount, [AdminUserId]
FROM [DbCRM].[dbo].[tblUserInfoRemarks]
GROUP BY [AdminUserId]
)AS ZZ5
) AS Z5 ON ( Z5.[ADMINUSERID] = Z3.[ADMINUSERID])' + CHAR(13) +
' LEFT JOIN [dbo].[tblSysDept] AS Z6 ON( Z3.[DeptId] = Z6.[DeptId])' + CHAR(13) +
' LEFT JOIN [dbo].[vw_UserInfo] AS Z7 ON( Z3.[AdminUserId] = Z7.[Id])' + CHAR(13) +
' WHERE Z3.[UID] >=' + CAST(@P_STARTINDEX AS VARCHAR(10)) +
' AND Z3.[UID] <= '+ CAST(@P_EndIndex AS VARCHAR(10)) + CHAR(13) +
' ) AS YY'; --一定要有别名YY,否则报')' 附近有语法错误。
SELECT DeptID, DeptName, AdminUserId, AdminUserName, AssignCount, TraceCount, UserIntention1, UserIntention2, UserIntention3, UserIntention4, UserIntention5, UserIntention6, UserIntention7
FROM (
SELECT
Z3.DeptId AS DeptID, Z6.DeptName AS DeptName,
Z3.AdminUserId AS AdminUserId, Z7.UserName AS AdminUserName,
Z4.AssignCount AS AssignCount,
Z5.TraceCount AS TraceCount,
Z3.UserIntention1 AS [UserIntention1],
Z3.UserIntention2 AS [UserIntention2],
Z3.UserIntention3 AS [UserIntention3],
Z3.UserIntention4 AS [UserIntention4],
Z3.UserIntention5 AS [UserIntention5],
Z3.UserIntention6 AS [UserIntention6],
Z3.UserIntention7 AS [UserIntention7]
FROM ' +
'##TempUserIntention AS Z3 ' + CHAR(13) +
' LEFT JOIN(
SELECT ZZ4.AssignCount, ZZ4.[AdminUserId]
FROM (
SELECT COUNT(DISTINCT [UserId]) AS AssignCount, [AdminUserId]
FROM [DbCRM].[dbo].[tblUserInfo]
GROUP BY [AdminUserId]
) AS ZZ4
) AS Z4 ON( Z4.[ADMINUSERID] = Z3.[ADMINUSERID])' + CHAR(13) +
' LEFT JOIN(
SELECT ZZ5.TraceCount, ZZ5.[AdminUserId]
FROM (
SELECT COUNT(DISTINCT [UserId]) AS TraceCount, [AdminUserId]
FROM [DbCRM].[dbo].[tblUserInfoRemarks]
GROUP BY [AdminUserId]
)AS ZZ5
) AS Z5 ON ( Z5.[ADMINUSERID] = Z3.[ADMINUSERID])' + CHAR(13) +
' LEFT JOIN [dbo].[tblSysDept] AS Z6 ON( Z3.[DeptId] = Z6.[DeptId])' + CHAR(13) +
' LEFT JOIN [dbo].[vw_UserInfo] AS Z7 ON( Z3.[AdminUserId] = Z7.[Id])' + CHAR(13) +
' WHERE Z3.[UID] >=' + CAST(@P_STARTINDEX AS VARCHAR(10)) +
' AND Z3.[UID] <= '+ CAST(@P_EndIndex AS VARCHAR(10)) + CHAR(13) +
' ) AS YY'; --一定要有别名YY,否则报')' 附近有语法错误。
0 0
- '@P0' 附近有语法错误
- top附近有语法错误
- Times附近有语法错误
- 关键字 ' ' 附近有语法错误。
- 关键字“ ”附近有语法错误
- 'Times' 附近有语法错误
- '(' 附近有语法错误
- 附近有语法错误
- '@P0'附近有语法错误
- @po附近有语法错误
- '@P0' 附近有语法错误
- 'OFFSET' 附近有语法错误。关键字 'AS' 附近有语法错误。
- 关键字 'USER' 附近有语法错误
- 关键字 'user' 附近有语法错误
- 关键字'User'附近有语法错误
- 关键字'User'附近有语法错误
- 关键字 'user' 附近有语法错误
- 关键字 'with' 附近有语法错误。
- pickle
- Linux——poll实现
- android版百度地图 自定义 点击当前位置弹出气泡
- qt/Embedded版本 修改编译工具 注意事项
- 服务器日志清理及IIS日志的清理
- 附近有语法错误
- BitSet的使用
- Quartz
- oracle2表关联修改
- Android 百度地图API-----气泡显示
- html 中 input 变成圆角
- 《读完忍不住流泪的文章:母亲,我怎么让妳等了那么久...》
- 校招
- 为Visual Studio添加默认INCLUDE包含路径一劳永逸的方法