27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT M_ID,
MAX(CASE WHEN [R_USER_ID]=[1] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[1] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[97] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[681] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[682] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[683] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[684] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[685] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[697] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[698] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[699] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[700] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[701] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[702] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[703] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[704] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[705] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[706] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[707] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[708] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[709] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[710] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[711] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[712] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[715] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[716] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[717] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[719] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[720] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[721] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[722] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[723] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[724] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[725] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[726] THEN M_ID ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[727]
--如何获取最后一个MAX的位置啊?
本意是获取最后一个max的位置,然后截取掉这部分字符串'MAX(CASE WHEN [R_USER_ID]=[727]’
--使得sql语句编译可以通过!
DECLARE @TT VARCHAR(300);
SET @TT='SELECT M_ID,MAX(CASE WHEN [R_USER_ID]=[1] THEN [M_ID] ELSE 0 END),MAX(CASE WHEN [R_USER_ID]=[1] THEN M_ID';
SET @TT=SUBSTRING(@TT,0,1000);
SET @TT=REVERSE(@TT);
SET @TT=REVERSE(SUBSTRING(@TT,CHARINDEX('(XAM', @TT),LEN(@TT)));
PRINT @TT;