Click here to Skip to main content
13,358,478 members (52,513 online)
   

Database

 
QuestionSQL Query Pin
berba29-Nov-12 3:22
memberberba29-Nov-12 3:22 
AnswerRe: SQL Query Pin
Richard Deeming29-Nov-12 3:50
memberRichard Deeming29-Nov-12 3:50 
GeneralRe: SQL Query Pin
berba2-Dec-12 19:30
memberberba2-Dec-12 19:30 
QuestionSQL Server windows authentication Pin
zead29-Nov-12 0:49
memberzead29-Nov-12 0:49 
AnswerRe: SQL Server windows authentication Pin
Garth J Lancaster29-Nov-12 0:59
memberGarth J Lancaster29-Nov-12 0:59 
AnswerRe: SQL Server windows authentication Pin
jschell29-Nov-12 9:09
memberjschell29-Nov-12 9:09 
GeneralRe: SQL Server windows authentication Pin
Chris Meech30-Nov-12 4:45
memberChris Meech30-Nov-12 4:45 
QuestionNeed help with a tricky MS SQL Query Pin
muya mwansa27-Nov-12 7:46
membermuya mwansa27-Nov-12 7:46 
Hi, I was given a tricky challenge question to attempt and allowed the use of any resources at my disposal. So far all my attempts have produced results close to the expected output but not quiet the expected out put. Here's the link to the question: Question and here's where you can test your query: test here.

Here's my query that produced the closest results:
SELECT        DISTINCT Competencies.CompName AS compname, Users.FirstName AS firstname, Users.SurName AS surname, CompPos.Level AS positionlevel, CompUser.Level AS userlevel
FROM            Positions INNER JOIN CompPos 
				ON Positions.PosId = CompPos.PosID 
				INNER JOIN Competencies   
				ON CompPos.CompID = Competencies.CompID
				INNER JOIN CompUser
				ON Competencies.CompID = CompUser.CompID	
				CROSS JOIN Users
WHERE 		(Users.UserId IN ('999209', 'helpdesk1', '999339', 'helpdesk5', '999827'))
AND        (CompUser.UserID IN ('999209', 'helpdesk1', '999339', 'helpdesk5', '999827'))
AND 		(Positions.Position LIKE '%Corp HR-People Development-Wellness-Manager(Process)%')
ORDER BY CompPos.Level DESC, Competencies.CompName, CompUser.Level, Users.FirstName, Users.SurName

AnswerRe: Need help with a tricky MS SQL Query Pin
Eddy Vluggen27-Nov-12 14:31
memberEddy Vluggen27-Nov-12 14:31 
GeneralRe: Need help with a tricky MS SQL Query Pin
jschell28-Nov-12 9:43
memberjschell28-Nov-12 9:43 
AnswerRe: Need help with a tricky MS SQL Query Pin
Deepak Kumar1128-Nov-12 2:03
memberDeepak Kumar1128-Nov-12 2:03 
QuestionBest Approach For Designing Database Pin
AmbiguousName27-Nov-12 4:59
memberAmbiguousName27-Nov-12 4:59 
AnswerRe: Best Approach For Designing Database Pin
jschell27-Nov-12 14:13
memberjschell27-Nov-12 14:13 
AnswerRe: Best Approach For Designing Database Pin
Mycroft Holmes27-Nov-12 14:14
memberMycroft Holmes27-Nov-12 14:14 
AnswerRe: Best Approach For Designing Database Pin
Eddy Vluggen27-Nov-12 14:23
memberEddy Vluggen27-Nov-12 14:23 
AnswerRe: Best Approach For Designing Database Pin
Krishna Kumar Soni3-Dec-12 2:04
memberKrishna Kumar Soni3-Dec-12 2:04 
QuestionEXEC sp_helptext Pin
jojoba201126-Nov-12 23:43
memberjojoba201126-Nov-12 23:43 
AnswerRe: EXEC sp_helptext Pin
Mycroft Holmes27-Nov-12 0:30
memberMycroft Holmes27-Nov-12 0:30 
QuestionRe: EXEC sp_helptext Pin
jojoba201127-Nov-12 0:38
memberjojoba201127-Nov-12 0:38 
AnswerRe: EXEC sp_helptext Pin
djj5527-Nov-12 1:59
memberdjj5527-Nov-12 1:59 
QuestionRe: EXEC sp_helptext Pin
jojoba201127-Nov-12 4:09
memberjojoba201127-Nov-12 4:09 
AnswerRe: EXEC sp_helptext Pin
Eddy Vluggen27-Nov-12 14:33
memberEddy Vluggen27-Nov-12 14:33 
QuestionRECORD VALIDATION IN ACCESS Pin
teto26-Nov-12 6:19
memberteto26-Nov-12 6:19 
SuggestionRe: RECORD VALIDATION IN ACCESS Pin
André Kraak26-Nov-12 6:56
memberAndré Kraak26-Nov-12 6:56 
AnswerRe: RECORD VALIDATION IN ACCESS Pin
djj5526-Nov-12 7:05
memberdjj5526-Nov-12 7:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy |
Web03 | 2.8.180111.1 | Last Updated 20 Jan 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid