Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Group By Question
Far too kind! Great, the last one did the job, perfect! It just looks so simple and straightforward, I feel so dumb, but I know there is a lot of know-how and expert knowledge in that..cool. cheers and many thanks to all. -
Group By Question
Here's a simplified version of the stringbuffer: select MonthYear, case when Format='PDF' then CountAbstractTypes else 0 end as PDF, case when Format='PALM' then CountAbstractTypes else 0 end as PALM from (SELECT Year(sendDate) as MonthYear, COUNT(abstractTypeId) AS CountAbstractTypes... -
Group By Question
Hi guys, Thanks for having received all your suggestions, I'll report on the results later. Funny enough is the fact that when planning the project I recommended to start with a new data base in order to set up kind of business intelligence system, appropriate to the needs and scale of the... -
Group By Question
Hi guys, I need assistance for this kind of sql result. I'm quite inexperienced with aggregate functions and grouping data after a selection. So here is what I get from my query so far: Year Total Format ------------------------------- 2002 1341 PDF 2002 77... -
Put into Collection
Yes, I think you're both right, Dian and jaxtell. I'll post it to SQL forum...Otherwise I'll come back to this one.. thanks guys oscar -
Put into Collection
Yes, unfortunately there is an important reason why I have to do this in Java: I can't figure out the right sql statement which returns the structure as required, although giving a try to Case, If, subqueries and other things I wanted to avoid... IMHO there is no sql statement to accomplish this... -
Put into Collection
Hello guys, I am new to java and have the following output from a sql resultset: Year: 2002 Total: 1341 Format: PDF Year: 2002 Total: 77 Format: PALM Year: 2002 Total: 1 Format: AUDIO Year: 2003 Total: 6596 Format: PDF Year: 2003 Total: 381 Format: PALM Year: 2003 Total: 3 Format: AUDIO Year...
