oseas1234

Amigos gostaria que esse select me retorne apenas a linha com o somatorio do total, mas preciso trazer no data do jeito que esta, so que ela esta repetindo as linhas. SELECT A.FICTEID,A.FIDIGITOVER,A.FCCTENOMBRE,A.FCCTERFC,b.fnPedTotal,CONVERT(CHAR(19),B.fdPedFec,103) AS DATA, SUM (b.fnPedTotal) TOTAL FROM CLIENTE A JOIN PEDIDO B WITH (NOLOCK) ON B.FICTEID=A.FICTEID AND B.fiDigitoVer =A.fiDigitoVer where A.FCCTERFC IS NOT NULL group by A.FICTEID,A.FIDIGITOVER,A.FCCTENOMBRE,A.FCCTERFC,b.fdPedFec ,b.fnPedTotal order by b.fdPedFec ---RETORNO ---- FICTEID FIDIGITOVER FCCTENOMBRE FCCTERFC fnPedTotal DATA TOTAL ----------- ----------- ------------------ -------------- -------------- ------------------- ---------------------------------------- 100011 2 ERICK 050119800010 314.94 08/03/2008 314.94 100011 2 ERICK 050119800010 467.14 08/03/2008 467.14 100001 1 PRUEBA 01111111111 314.94 09/03/2008 314.94 100001 1 PRUEBA 01111111111 314.94 09/03/2008 314.94 100011 2 ERICK 050119800010 358.25 09/03/2008 358.25