Welcome to Sign in | Help
in Search

inline function

Last post 04-03-2009, 1:53 PM by neo. 4 replies.
Sort Posts: Previous Next
  •  04-02-2009, 5:07 PM 7013

    inline function

    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.


    G.
  •  04-02-2009, 6:57 PM 7014 in reply to 7013

    Re: inline function

    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
  •  04-02-2009, 7:53 PM 7016 in reply to 7014

    Re: inline function

    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.
  •  04-02-2009, 8:18 PM 7017 in reply to 7016

    Re: inline function

    Păi atunci, încearcă:

    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

    Nu merge aşa?

    Răzvan

  •  04-03-2009, 1:53 PM 7021 in reply to 7017

    Re: inline function

    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

     


    G.
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems