razvan, la mine prefix practic e un rtrim lung, order by-ul nu il mai am , iar in sum(nr) nr e count-ul din select. Select-ul imi merge, dar daca il prefixez cu un altul in care imi pun si sum nu mai merge
zice incorect sintax near keyword 'group'
script-ul practic este acesta:
select
rtrim(rtrim(prefix)+rtrim(tel)) as prefix, count(*) as nr from dbo.tabel where (conditie = 'ceva')
and
(prefix like '08%') and
(
year(created)=2000 )
group
by rtrim(rtrim(prefix)+rtrim(tel))
having
count(*)<=100
multumesc
G.