Re: sql help needed

select sum(ilneprice) suma, case
  when ilninvdate between '02/01/2005' and '10/31/2005' then 1
  when ilninvdate between '11/01/2005' and '11/30/2005' then 2
...
  else 0
end as period
from...
where..
group by period

You will get a row for each period.
__________________________________________________________________________
Douglas W. Palme wrote:

Its been a few weeks since I last posted, and its been a over a week since I was even at work....actually I kind of missed a lot of you :) Trying to get some rest and recoup time in a hospital bed just does not seem to ever work.

Alas, I am back, working on another stupid SQL problem. If someone could point me in the right direction on this I would appreciate it.

I need to extract a sum of our line items for two separate date ranges, IE: select sum(ilneprice) as current from speclf where ilninvdate >'02/01/2005' and ilninvdate <='10/31/2005'

That works just fine, but I also need to extract a sum for the same field (ilneprice) for a different date range....is it possible to do this without having to run the query two separate times? Because I also need to extract some other information and group it by location codes and item numbers....

Any help would be appreciated.

Douglas


If you bought it, it was hauled by a truck - somewhere, sometime.