salut,

cum pot extrage din selectul de mai jos prefixul si sum(nr) ptr fiecare prefix in parte?

(select prefix, datepart(dd, DataCreare), count(*) as nr from tabel

where conditii

group by prefix, datepart(dd, DataCreare),

having count(*)<=10

order by prefix, datepart(dd, DataCreare), nr )

multumesc.