| Author |
 Topic  |
|
|
jia9211
Starting Member
7 Posts |
 Posted - 06/21/2004 : 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 - 06/21/2004 : 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
USA
4184 Posts |
Posted - 06/21/2004 : 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. |
|
|
| |
Topic |
|
|
|
Urgent Help Required
