Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

~249 People Reached
Favorite Forums
Favorite Tags
Member Avatar for Gdyson

Hi I'm trying to query the following tables to find out the Resource Companyname and Project Title for any Recruiters who have worked on more than/less than 6 projects within a specified period. These are the tables: dbo.tblResources ResourceID Company Name dbo.tblRecruiters RecruiterID ResourceID dbo.tblProjects ProjectID Datecreated dbo.tblProfiles ProfileID ProjectID …

Member Avatar for Gdyson
0
103
Member Avatar for Gdyson

This looks pretty simple on the face of it but I can't get my head around it. I have two tables that I'm querying: dbo.tblrespondents RespondentID FirstName Surname dbo.tblrespondentschildren RespondentsChildID RespondentID ChildFirstName ChildSurname ChildDOB ChildSex I am trying to find which Respondents who have only sons - one must be …

Member Avatar for darkagn
0
146