Date query help

[Giorgio]

I have a table with a date_created and date_expired and I want to look
at the 15th of each month and every month since the system started and
count up how many accounts were active at each of those points in
time.
Will have to assume that if there's an expiry date bigger than today
then that account was active at each of those points in time.

Can someone pelase tell me how can I do that?

Thanks a lot

[Hugo Kornelis]

Re: Date query help

On 19 Mar 2007 10:14:33 -0700, Giorgio wrote:

>I have a table with a date_created and date_expired and I want to look
>at the 15th of each month and every month since the system started and
>count up how many accounts were active at each of those points in
>time.
>Will have to assume that if there's an expiry date bigger than today
>then that account was active at each of those points in time.
>
>Can someone pelase tell me how can I do that?
>
>Thanks a lot

Hi Giorgio,

This question has already been answered in
microsoft.publi c.sqlserver.pro gramming. In the future, please do not
multipost your questions, as it might cause people to waste time
figuring out an answer to a question that's already been answered
elsewhere.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis