Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Complex Query
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Complex Query
Divers
Thread ID:
00421451
Message ID:
00421451
Vues:
41
Ok heres the quandry:

I have three table and views as follows:
Budget(B)         viewCourses(VC)   viewRequests(VR)
<HR WIDTH="410" ALIGN="left">
ID                ID                ID
fy_start          Name              ReqDate
fy_end            Number            Course
Amount            Type              FirstName
StaffCount        Competancy        LastName
OverallITBudget   Length            Department
                  Units             Coordinator
                  Comments          Priority
                  TypeID            Status
                  CompetancyID      LateCancel
                  UnitsID           Comments
                                    ActualCost
                                    CourseID
                                    EmployeeID
                                    PriorityID
                                    StatusID
                                    LateCancelID
                                    DeliveryDate
                                    Vendor
                                    Date

With these three tables I need to create a SQL query that returns
the following columns:
1. Total Staff Trained               Unique Count of VR.EmployeeID
2. Percent of Government IT Staff    1 / B.StaffCount
3. Dollars Spent                     Sum Actual Cost
4. Average Dollars Spent per Person  3 / 1
5. Training Days	             Sum(VC.CourseLength) for each request.
6. Average Training Days per Person  5 / 1
I don't even know how to begin on this query. I know SQL but...this is driving me crazy. PLz Help!!! 8o
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform