if profileId=2379 then diaplay other profileid s (organization hierarchy) how to do this query any one can help me

Question

1.00/5 (1 vote)

See more:

ProfileID	                     Profile	        
0	                             Super Admin	 
2378	                             Admin	         
2379	                             Software Engineer 
2380	                             Program Manager	  
2381	                             Project Manager	 
2382	                             Tech Lead	 
2383	                             Tester     	  
2384	                             DBA	        
2385	                             Onsite Project Manager	
2386	                             Account Manager	
2387	                             HRM	         
2388	                             NOC Support	
2389	                            QA Manager	
2390	                            Trainee        	
2391	                            Business Development Manager 
2392	                            Business Development Team    
2393	                            Team Lead	
2394	                            Process Head	
2395	                            IT Administration 
2396	                            NOC Trainee     
2397	                            Technical Architect	
2398	                            DB Developer	
2399	                            NOC Team Lead	
2400	                            Content Writer

Posted 12-Jan-14 20:26pm

Member 10501509

Updated 12-Jan-14 21:41pm

Aarti Meswania

v4

Add a Solution

Comments

Member 10501509 13-Jan-14 2:27am

if profile='software engg' then display higher profile than software engg

Peter Leow 13-Jan-14 2:44am

First of all, how do you differentiate hierarchy of profile? e.g. software engineer vs trainee, common sense will tell but not to a computer.

Member 10501509 13-Jan-14 2:48am

By using profileID s

Peter Leow 13-Jan-14 2:49am

No can do. e.g. the profileID for software engineer, project manager, and trainee are 2379, 2381, and 2390.

Member 10501509 13-Jan-14 2:51am

if ProfileID=2379 then display remaining ProfileID

Gandalf_TheWhite 13-Jan-14 2:51am

I guess this person have no clue over the parent child(hierarchy)

Gandalf_TheWhite 13-Jan-14 2:41am

Please explain your problem precisely. How do you determine the higher level and lower level hierarchy.

Member 10501509 13-Jan-14 2:43am

By using profileID s

Member 10501509 13-Jan-14 2:50am

if ProfileID=2379 then display remaining ProfileID

Gandalf_TheWhite 13-Jan-14 2:51am

What is the parent ID in your case?

Member 10501509 13-Jan-14 2:52am

ProfileID

Member 10501509 13-Jan-14 2:52am

profileID

Member 10501509 13-Jan-14 3:00am

parent

Gandalf_TheWhite 13-Jan-14 3:02am

Can you send table structure of this table. Still you're missing the point to explain on basis we can provide you the solution.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2014-01-12T20:53:00

If I understand you correctly now, you want to retrieve detail of a profile id, but if the profile id is 2379, then show all profile id other than 2379, right? Then may be the following stored procedure will help, or you can adapt it:

SQL

CREATE PROCEDURE spGetProfile
(
   @para int
)
AS
DECLARE @tmpType VARCHAR(15)
BEGIN
IF(@para = 2379)
    BEGIN
    SELECT * FROM tablename WHERE profileid <> @para
    END
ELSE
    BEGIN
    SELECT * FROM tablename WHERE profileid = @para
    END
END

then call this procedure like this:

EXEC dbo.spGetProfile  @para = 2378;

or

EXEC dbo.spGetProfile  @para = other profile id;