Re: DB Design help?

From: Michael A. Angelo <mangelo123_at_email.msn.com>
Date: Mon, 21 Feb 2000 23:40:42 -0500
Message-ID: <#Ve3N8Of$GA.264@cpmsnbbsa04>

I would find a reporting tool that does crosstabs. Most of them do this.

What you would do is make the columns of the crosstab the month name and the rows would be the day number. The data cells would be the count respetive of the month and day.

Only restriction here is there must be at least one entry per day number (1, 2, ...31). Not each day for each month. Just at least one entry per day do that all numbers will appear on the report.

Once you understand crosstabs, this is very easy.

--

---

Michael A. Angelo
Certified Java Programmer
Chief Technology Officer
Soleil Technologies LLC
Pittsburgh, PA

www.soleiltech.com

Ben Heuer <queerczarNOquSPAM_at_unforgettable.com.invalid> wrote in message news:05fb87e0.2030c446_at_usw-ex0103-019.remarq.com...
> Hello
>
> Pls direct me to a correct group if this happens to be a mispost.
>
> I need some help with database design..I have a table that
> stores the time that a user logged in to a web site. Now I have
> been asked to make a report in the following format:
>
> Jan Feb Mar....
>
> 1
> 2
> 3
> .
> .
> .
> 31
>
>
> How can I do this using either SQL or some third party tool??
>
> I'd really be obliged if I some one could help me..I cannot seem
> to work out an SQL where I can enlist so many COUNTS(*)
> statements!!
>
> Thanks very much in advance!
>
> Regards
> Ben
>
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon Feb 21 2000 - 22:40:42 CST