Sum - group - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Sum - group

Author

Topic

ymamalis
Starting Member

42 Posts

Posted - 2010-03-08 : 08:11:09

Hi i want to group the results of this query
SELECT APOD_prom_ana_eidos_kal_apod.kvd_synergath_old, APOD_prom_ana_eidos_kal_apod.id_Ontot_Paragogos,
SUM(APOD_prom_ana_eidos_kal_apod.poso) * APOD_apodeijeis.isotimia AS Poso, APOD_prom_ana_eidos_kal_apod.hmer_plhrom_prom,
APOD_prom_ana_eidos_kal_apod.kvd_synergath
FROM APOD_prom_ana_eidos_kal_apod INNER JOIN
APOD_apodeijeis ON APOD_prom_ana_eidos_kal_apod.id_apod = APOD_apodeijeis.id_apod
GROUP BY APOD_prom_ana_eidos_kal_apod.kvd_synergath_old, APOD_prom_ana_eidos_kal_apod.id_Ontot_Paragogos,
APOD_prom_ana_eidos_kal_apod.hmer_plhrom_prom, APOD_prom_ana_eidos_kal_apod.kvd_synergath, APOD_apodeijeis.isotimia
HAVING (APOD_prom_ana_eidos_kal_apod.hmer_plhrom_prom = @date)

i tried

SELECT SUM(Poso) AS Expr1
FROM (SELECT APOD_prom_ana_eidos_kal_apod.kvd_synergath_old AS kvd, APOD_prom_ana_eidos_kal_apod.id_Ontot_Paragogos, SUM(APOD_prom_ana_eidos_kal_apod.poso) * APOD_apodeijeis.isotimia AS Poso,
APOD_prom_ana_eidos_kal_apod.hmer_plhrom_prom, APOD_prom_ana_eidos_kal_apod.kvd_synergath
FROM APOD_prom_ana_eidos_kal_apod INNER JOIN
APOD_apodeijeis ON APOD_prom_ana_eidos_kal_apod.id_apod = APOD_apodeijeis.id_apod
GROUP BY APOD_prom_ana_eidos_kal_apod.kvd_synergath_old, APOD_prom_ana_eidos_kal_apod.id_Ontot_Paragogos, APOD_prom_ana_eidos_kal_apod.hmer_plhrom_prom, APOD_prom_ana_eidos_kal_apod.kvd_synergath,
APOD_apodeijeis.isotimia
HAVING (APOD_prom_ana_eidos_kal_apod.hmer_plhrom_prom = @date)) AS tbl1

but iam getting an error
can yoy help me?

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-03-08 : 08:45:15

What error you are getting?

Vabhav T

ymamalis
Starting Member

42 Posts

Posted - 2010-03-08 : 09:08:53

invalid object name apod_prom_ana_eidos_kal_apod

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-08 : 09:41:51

is APOD_prom_ana_eidos_kal_apod table on same db?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

ymamalis
Starting Member

42 Posts

Posted - 2010-03-08 : 11:20:45

sorry my friend . !!!!!! i was running the whole query on a wrong db !!!!!!!!!!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-08 : 11:22:11

So i guessed it right

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources