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.
| Author |
Topic |
|
thedreamshaper
Starting Member
2 Posts |
 Posted - 2010-06-25 : 07:02:27
|
Hi all,So i am trying to get these 3 columns of data and it keeps claiming that my code is "not a single group function"My code being: quote:
Select exp(sum(ln(AFKASTPCT/100+1))) , DATO , exp(sum(ln(REFERENCEPCT/100+1))) from PROD_BJOR_REP_PORTMAN_MAINT.PORTFOLIO_PERFORMANCE where KUNDENR ='0000000812' and RESTYPE='RS7' and dato between '2010-01-01' and '2010-05-01'order by DATO
I figure somehow a group by might help but since i never used one before i was hoping for some help :)Cheers |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-06-25 : 07:38:20
|
| Are you using SQL Server?Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
 |
|
|
thedreamshaper
Starting Member
2 Posts |
Posted - 2010-06-25 : 07:43:46
|
I believe i am, though not sure (sorry)I am using a program called AQTdoes that help ?quote:
Originally posted by Idera
Are you using SQL Server?Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH
|
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-06-25 : 07:59:34
|
| I am not sure how the query will be interprted but I think you are missing a group by clause.Just put group by DATO after "between '2010-01-01' and '2010-05-01'"Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
|
|
|
sum group