我认为您还需要通过表达式在您的组中复制您的collate子句：
SELECt E.HESAP, B.TEKLIF_NO1 + '/' COLLATE Turkish_CI_AS + B.TEKLIF_NO2 AS 'TEKLIF', E.MUSTERI,ConVERT(VARCHAr(10),B.ISL_TAR,103) AS 'TARIH', SUM( ISNULL(CAST(B.ODENEN_ANAPARA AS FLOAT),0)+ISNULL(CAST(B.FAIZ AS FLOAT),0)+ ISNULL(CAST(B.BSMV AS FLOAT),0)+ISNULL(CAST(B.GECIKME_FAIZ AS FLOAT),0)+ ISNULL(CAST(B.GECIKME_BSMV AS FLOAT),0)) AS 'YATAN', (CASE WHEN C.DOVIZ_KOD = 21 THEN 'EUR' WHEN C.DOVIZ_KOD = 2 THEN 'USD' WHEN C.DOVIZ_KOD = 1 THEN 'TL' END) AS 'KUR', E.AVUKAT, ConVERT(VARCHAr(10),A.ICRA_TAR,103) AS '陌CRA TAR陌H陌', ConVERT(VARCHAr(10),A.HACIZ_TAR,103) AS 'HAC陌Z TAR陌H陌' FROM TAKIP A, YAZ..MARDATA.BIR_TAHSIL B, YAZ..MARDATA.S_TEKLIF C,P_TAKIP_SR D, AVUKAT E WHERe B.TEKLIF_NO1 = C.TEKLIF_NO1 AND B.TEKLIF_NO2 = C.TEKLIF_NO2 AND A.T_HESAP_NO = C.HESAP_NO AND C.HESAP_NO = B.HESAP_NO AND B.HESAP_NO = E.HESAP AND A.T_SRM = D.T_SR_ID AND A.T_STATU = 2 AND A.T_SRM <> 6GROUP BY C.HESAP_NO, B.TEKLIF_NO1 + '/' COLLATE Turkish_CI_AS + B.TEKLIF_NO2,B.ISL_TAR,C.DOVIZ_KOD, E.HESAP, E.MUSTERI, E.AVUKAT, A.ICRA_TAR, A.HACIZ_TAR
