Urgent Help Required - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Urgent Help Required

Author

Topic

jia9211
Starting Member

7 Posts

Posted - 2004-06-21 : 01:57:04

Hi,
I have following tables

Technology[TechnologyId,TechnologyName]
Seniority[SeniorityId,SeniorityName]
ResourceTechnology[ResTechId,ResId,TechId]
ResourceSeniority[ResSenId,ResId,SenId,FromDate,ToDate]

I want to get following result:

1.Total number of resources in each seniority
2.Total number of resources in each technology within each
3.Total number of available resources in each Seniority
4.Total number of available resources in each technology within each

e.g,
SenioriyName|TotalRes|SAvailableRes|TechnologyName|TotalRes|TAvailableRes

Please help urgently, thanks

jia9211
Starting Member

7 Posts

Posted - 2004-06-21 : 02:07:22

Onething i forgot to mention is we will check availability at some specific date.(e.g.,at 6/4/2004)

Mean get above mention report of all resources who are avialbe at 6/4/2004. etc.
thanks

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-06-21 : 13:48:05

Have you looked at the SELECT, INNER JOIN, and WHERE statements in SQL Server Books Online?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources