SELECT
CONVERT(VARCHAR(10),D_Date,120) AS [日期],
COL_RP_CODE AS [打叶计划],
(SELECT MAX(C_CustCode) FROM T_OutByMachineDetail WHERE V_LineCode = '001' AND CONVERT(VARCHAR(10),D_Date,120) = CONVERT(VARCHAR(10),T1.D_Date,120) AND COL_RP_CODE = T1.COL_RP_CODE AND C_CustCode = T1.C_CustCode AND V_GBGradeCode = T1.V_GBGradeCode) AS ' 客户'
FROM T_OutByMachineDetail T1
GROUP BY CONVERT(VARCHAR(10),D_Date,120),COL_RP_CODE,C_CustCode,V_GBGradeCode
ORDER BY CONVERT(VARCHAR(10),D_Date,120) ASC,[打叶计划] ASC,' 客户' DESC
CONVERT(VARCHAR(10),D_Date,120) AS [日期],
COL_RP_CODE AS [打叶计划],
(SELECT MAX(C_CustCode) FROM T_OutByMachineDetail WHERE V_LineCode = '001' AND CONVERT(VARCHAR(10),D_Date,120) = CONVERT(VARCHAR(10),T1.D_Date,120) AND COL_RP_CODE = T1.COL_RP_CODE AND C_CustCode = T1.C_CustCode AND V_GBGradeCode = T1.V_GBGradeCode) AS ' 客户'
FROM T_OutByMachineDetail T1
GROUP BY CONVERT(VARCHAR(10),D_Date,120),COL_RP_CODE,C_CustCode,V_GBGradeCode
ORDER BY CONVERT(VARCHAR(10),D_Date,120) ASC,[打叶计划] ASC,' 客户' DESC
COL_RP_CODE AS [打叶计划],
MAX(C_CustCode) AS ' 客户'
FROM T_OutByMachineDetail T1 WITH(NOLOCK)
WHERE V_LineCode = '001'
GROUP BY D_Date,COL_RP_CODE,C_CustCode,V_GBGradeCode
ORDER BY D_Date ASC,
[打叶计划] ASC,
' 客户' DESC不知道这样有没有改变你的业务逻辑,你测试一下