Re: SQL problem enclosed. SELECTing moving window of values...
From: Lennart Jonsson <lennart_at_kommunicera.umea.se>
Date: Wed, 07 Nov 2001 22:10:07 GMT
Message-ID: <3jiG7.16697$xS6.26774_at_www.newsranger.com>
Date: Wed, 07 Nov 2001 22:10:07 GMT
Message-ID: <3jiG7.16697$xS6.26774_at_www.newsranger.com>
Remo, this is just an idea but you might be able to extend it something that is working
select monthname(a.changedate), count(1) from workstat as a, (select distinct month(changedate) from workstat) as b(m) where month(a.changedate) >= b.m and a.changedate <= '3/1/2000' and a.wostat = 'INPRG' group by monthname(a.changedate)
/Lennart Received on Wed Nov 07 2001 - 23:10:07 CET