Re: Need help for SQL query

Gees,

I don't see a specific question here but rather "Will you Design and Code" this system for me!!

You first need to have a properly and sufficiently designed database model before you can begin to write code. Do you have a logical ERD or a physical ERD? What are some of the entities, and relationships for this application. Once we see this kind of info we may be able to help with a query.

Kevin Gillins

"Janardana Neelakanta" <janardan_n_at_hotmail.com> wrote in message news:3D87374D.E1CB1DC9_at_hotmail.com...
> Hi all,
>
> I have situation like this:
>
> There are so many types of resources like printers,
> scanners,conference rooms etc... Printers type can have so many
> individual printers. Similar case applies to all the resources.
> A reservation system has been developed to reserve each of these
> resources.
>
> I need to write a query which displays those individual resources in
> each type, that have been used (reserved) to the maximum extent for a
> particular time slot.
>
> If the specific problem is needed, please let me know.
>
> Please get me some idea on how to proceed to write the query.
>
> Many thanks and Regards
> Janardan
>
>
>
Received on Tue Sep 17 2002 - 09:26:16 CDT