Click here to Skip to main content
       

Database

 
GeneralSQL instance name when using network group PinmemberAamir Saleem2-Dec-12 10:32 
GeneralRe: SQL instance name when using network group PinmemberMycroft Holmes2-Dec-12 11:43 
QuestionACL vs SQL for fuzzy matching PinmemberBen Dessau29-Nov-12 4:15 
AnswerRe: ACL vs SQL for fuzzy matching PinprotectorPete O'Hanlon29-Nov-12 5:07 
GeneralRe: ACL vs SQL for fuzzy matching PinmemberBen Dessau29-Nov-12 6:43 
GeneralRe: ACL vs SQL for fuzzy matching PinprotectorPete O'Hanlon29-Nov-12 6:50 
QuestionSQL Query Pinmemberberba29-Nov-12 2:22 
AnswerRe: SQL Query PinmemberRichard Deeming29-Nov-12 2:50 
GeneralRe: SQL Query Pinmemberberba2-Dec-12 18:30 
QuestionSQL Server windows authentication Pinmemberzead28-Nov-12 23:49 
AnswerRe: SQL Server windows authentication PinmemberGarth J Lancaster28-Nov-12 23:59 
AnswerRe: SQL Server windows authentication Pinmemberjschell29-Nov-12 8:09 
GeneralRe: SQL Server windows authentication PinmemberChris Meech30-Nov-12 3:45 
QuestionNeed help with a tricky MS SQL Query Pinmembermuya mwansa27-Nov-12 6: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 PinmemberEddy Vluggen27-Nov-12 13:31 
GeneralRe: Need help with a tricky MS SQL Query Pinmemberjschell28-Nov-12 8:43 
AnswerRe: Need help with a tricky MS SQL Query PinmemberDeepak Kumar1128-Nov-12 1:03 
QuestionBest Approach For Designing Database PinmemberAmbiguousName27-Nov-12 3:59 
AnswerRe: Best Approach For Designing Database Pinmemberjschell27-Nov-12 13:13 
AnswerRe: Best Approach For Designing Database PinmemberMycroft Holmes27-Nov-12 13:14 
AnswerRe: Best Approach For Designing Database PinmemberEddy Vluggen27-Nov-12 13:23 
AnswerRe: Best Approach For Designing Database PinmemberKrishna Kumar Soni3-Dec-12 1:04 
QuestionEXEC sp_helptext Pinmemberjojoba201126-Nov-12 22:43 
AnswerRe: EXEC sp_helptext PinmemberMycroft Holmes26-Nov-12 23:30 
QuestionRe: EXEC sp_helptext Pinmemberjojoba201126-Nov-12 23:38 
AnswerRe: EXEC sp_helptext Pinmemberdjj5527-Nov-12 0:59 
QuestionRe: EXEC sp_helptext [modified] Pinmemberjojoba201127-Nov-12 3:09 
AnswerRe: EXEC sp_helptext PinmemberEddy Vluggen27-Nov-12 13:33 
QuestionRECORD VALIDATION IN ACCESS Pinmemberteto26-Nov-12 5:19 
SuggestionRe: RECORD VALIDATION IN ACCESS PinmemberAndré Kraak26-Nov-12 5:56 
AnswerRe: RECORD VALIDATION IN ACCESS Pinmemberdjj5526-Nov-12 6:05 
Questionhow to compare an operation in where expression In sql [modified] PinmemberGREG_DORIANcod26-Nov-12 4:29 
AnswerRe: how to compare an operation in where expression In sql Pinmembers_magus26-Nov-12 5:20 
AnswerRe: how to compare an operation in where expression In sql PinmemberMycroft Holmes26-Nov-12 11:56 
Questiongrant permission on table in another database PinmemberDan_K26-Nov-12 3:55 
QuestionRe: grant permission on table in another database PinmemberChris Meech26-Nov-12 8:25 
QuestionHow to mearge local database with server database PinmemberJitendra Parida198723-Nov-12 22:00 
AnswerRe: How to mearge local database with server database PinmemberMycroft Holmes23-Nov-12 22:17 
AnswerRe: How to mearge local database with server database Pinmemberdjj5525-Nov-12 2:48 
GeneralRe: How to mearge local database with server database PinmemberJitendra Parida198725-Nov-12 18:13 
GeneralRe: How to mearge local database with server database PinmemberGREG_DORIANcod26-Nov-12 5:56 
AnswerRe: How to mearge local database with server database PinmemberDeepak Kumar1128-Nov-12 1:31 
RantStupid bloody idiot PinmemberMycroft Holmes18-Nov-12 21:25 
GeneralRe: Stupid bloody idiot PinmemberJ4amieC18-Nov-12 22:39 
GeneralRe: Stupid bloody idiot PinmemberRichard Deeming19-Nov-12 1:46 
GeneralRe: Stupid bloody idiot PinmemberMycroft Holmes19-Nov-12 11:43 
Questionlogin with another user faile problem Pingroupmehdi.sabet18-Nov-12 21:11 
AnswerRe: login with another user faile problem PinmemberMycroft Holmes18-Nov-12 21:20 
AnswerRe: login with another user faile problem PinmemberJoy Sinha22-Nov-12 20:02 
QuestionDATABASE QUESTIOM PinmemberMegha Rohilla18-Nov-12 9:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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 | Mobile
Web03 | 2.8.140721.1 | Last Updated 21 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid