Click here to Skip to main content
12,076,727 members (46,065 online)
   

Database

 
GeneralSQL instance name when using network group Pin
Aamir Saleem2-Dec-12 11:32
memberAamir Saleem2-Dec-12 11:32 
GeneralRe: SQL instance name when using network group Pin
Mycroft Holmes2-Dec-12 12:43
memberMycroft Holmes2-Dec-12 12:43 
QuestionACL vs SQL for fuzzy matching Pin
Ben Dessau29-Nov-12 5:15
memberBen Dessau29-Nov-12 5:15 
AnswerRe: ACL vs SQL for fuzzy matching Pin
Pete O'Hanlon29-Nov-12 6:07
protectorPete O'Hanlon29-Nov-12 6:07 
GeneralRe: ACL vs SQL for fuzzy matching Pin
Ben Dessau29-Nov-12 7:43
memberBen Dessau29-Nov-12 7:43 
GeneralRe: ACL vs SQL for fuzzy matching Pin
Pete O'Hanlon29-Nov-12 7:50
protectorPete O'Hanlon29-Nov-12 7:50 
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 
Questionhow to compare an operation in where expression In sql Pin
GREG_DORIANcod26-Nov-12 5:29
memberGREG_DORIANcod26-Nov-12 5:29 
AnswerRe: how to compare an operation in where expression In sql Pin
s_magus26-Nov-12 6:20
members_magus26-Nov-12 6:20 
AnswerRe: how to compare an operation in where expression In sql Pin
Mycroft Holmes26-Nov-12 12:56
memberMycroft Holmes26-Nov-12 12:56 
Questiongrant permission on table in another database Pin
Dan_K26-Nov-12 4:55
memberDan_K26-Nov-12 4:55 
QuestionRe: grant permission on table in another database Pin
Chris Meech26-Nov-12 9:25
memberChris Meech26-Nov-12 9:25 
QuestionHow to mearge local database with server database Pin
Jitendra Parida198723-Nov-12 23:00
memberJitendra Parida198723-Nov-12 23:00 
AnswerRe: How to mearge local database with server database Pin
Mycroft Holmes23-Nov-12 23:17
memberMycroft Holmes23-Nov-12 23:17 
AnswerRe: How to mearge local database with server database Pin
djj5525-Nov-12 3:48
memberdjj5525-Nov-12 3:48 
GeneralRe: How to mearge local database with server database Pin
Jitendra Parida198725-Nov-12 19:13
memberJitendra Parida198725-Nov-12 19:13 
GeneralRe: How to mearge local database with server database Pin
GREG_DORIANcod26-Nov-12 6:56
memberGREG_DORIANcod26-Nov-12 6:56 
AnswerRe: How to mearge local database with server database Pin
Deepak Kumar1128-Nov-12 2:31
memberDeepak Kumar1128-Nov-12 2:31 
RantStupid bloody idiot Pin
Mycroft Holmes18-Nov-12 22:25
memberMycroft Holmes18-Nov-12 22:25 
GeneralRe: Stupid bloody idiot Pin
J4amieC18-Nov-12 23:39
memberJ4amieC18-Nov-12 23:39 
GeneralRe: Stupid bloody idiot Pin
Richard Deeming19-Nov-12 2:46
memberRichard Deeming19-Nov-12 2:46 
GeneralRe: Stupid bloody idiot Pin
Mycroft Holmes19-Nov-12 12:43
memberMycroft Holmes19-Nov-12 12:43 
Questionlogin with another user faile problem Pin
mehdi.sabet18-Nov-12 22:11
groupmehdi.sabet18-Nov-12 22:11 
AnswerRe: login with another user faile problem Pin
Mycroft Holmes18-Nov-12 22:20
memberMycroft Holmes18-Nov-12 22:20 
AnswerRe: login with another user faile problem Pin
Joy Sinha22-Nov-12 21:02
memberJoy Sinha22-Nov-12 21:02 
QuestionDATABASE QUESTIOM Pin
Megha Rohilla18-Nov-12 10:34
memberMegha Rohilla18-Nov-12 10:34 

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 | Mobile
Web01 | 2.8.160212.1 | Last Updated 12 Feb 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid