T-SQL

Re: inline function

neo — Fri, 03 Apr 2009 10:53:14 GMT

este ok

merge

cauza ptr care nu mergea era faptul ca e OBLIGATORIU sa folosesc un alias ptr select-ul meu . iar eu nu foloseam...

SELECT prefix, SUM(nr) AS total
FROM (

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

) t
GROUP BY prefix
ORDER BY prefix, total

Re: inline function

rsocol — Thu, 02 Apr 2009 17:18:16 GMT

Păi atunci, încearcă:

SELECT prefix, SUM(nr) AS total
FROM (

) t
GROUP BY prefix
ORDER BY prefix, total

Nu merge aşa?

Răzvan

Re: inline function

neo — Thu, 02 Apr 2009 16:53:07 GMT

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

Re: inline function

rsocol — Thu, 02 Apr 2009 15:57:10 GMT

Poţi folosi pur şi simplu:

SELECT prefix, SUM(nr) AS total
FROM (
... select-ul tau (fara ORDER BY)...
) t
GROUP BY prefix
ORDER BY prefix, total

Răzvan

inline function

neo — Thu, 02 Apr 2009 14:07:47 GMT

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.