How to writ If condition in SQL using procedure

Question

1.00/5 (1 vote)

See more:

Hello
There are any one to writ a small SQL query
I writ the below procedure, Here are tow field [Headmaster],[Gender]
which the have value '1' or value '2'

Now I want select a IF condition on this field like below

If Teachers_TB.HeadMaster_Teacher value=1 select 'Teacher' this name must be display

If Teachers_TB.HeadMaster_Teacher value=2 select 'HeadMaster' this name must display

Also
IF Teachers_TB.Gender value=1 select 'Male' this name must be display

If Teachers_TB.Gender value=2 Select 'Female' this name must be display
Thanks

my procedure:

SQL

ALTER proc [dbo].[ExportDatatoExcel]
as
begin

select PName_en,DName_en,SName,Code,Type,Grade,School.Gender,

Enrolled_Male,Enrolled_Female,Passed_Male,Passed_Female,
Failed_Male,Failed_Female,PermanentAbsent_Male,PermanentAbsent_Female,
DropOut_Male,DropOut_Female,

HeadMaster_Teachers,Teachers_TB.Gender,Phd,Master,Bachelors,TED15,TED14,TED12,
Vocational14,Vocational12,RelegiousMadrasa14,RelegiousMadrasa12,Sport14,Sport12,
General12,LowerSecondary,Primaryt,Private,
TeachersTashkeel,Male,Female

from School
join Province on School.ProvinceID=Province.P_ID
join District on School.DistrictID=District.D_ID
INNER JOIN Students ON School.S_ID = Students.Student_ID
join Teachers_TB on Teachers_TB.Teacher_ID=School.S_ID
join Tashkeel on Tashkeel.TashkeelID=School.S_ID
Order by P_ID,D_ID

end

Posted 16-Jun-15 0:59am

Member 11240896

Add a Solution

2 solutions

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)

Andy Lanng · Accepted Answer · 2015-06-16T01:09:00

Solution 1

User CASE x THEN y ELSE z END as myfield

SQL

select 
    column1,
    column2,
    CASE Teachers_TB.HeadMaster_Teacher 
      WHEN 1 THEN 'Teacher'
      WHEN 2 THEN 'HeadMaster'
    END AS column3Name,
    CASE Teachers_TB.Gender
      WHEN 1 THEN 'Male'
      WHEN 2 THEN 'Female'
    END AS column4Name,
from
....

Posted 16-Jun-15 1:09am

Andy Lanng

Comments

Member 11240896 16-Jun-15 7:23am

Thanks sir
How to set space between this column name END AS [HeadMaster Teachers],

WHEN 1 THEN 'Teacher'
WHEN 2 THEN 'HeadMaster'
END AS HeadMaster Teachers,

Member 11240896 16-Jun-15 7:29am

Also I export the data to excel but in excel does not print the Name of HeadMaster and Gender yet the value of them display in the excel

Andy Lanng 16-Jun-15 7:38am

That's a new question.

Please post a new question on the forums.

Be sure to include the code you use to export to excel

Andy Lanng 16-Jun-15 7:26am

exactly as you just had it ^_^

Square brackets ([ & ]) means a literal name - i.e. END AS [HeadMaster Teachers].

This is correct ^_^

Member 11240896 16-Jun-15 7:37am

Sir here is anther problem
I need to add this condition between above procedure
please help

Member 11240896 · Accepted Answer · 2015-06-16T02:05:00

I solution this problem
All Code Work right any one can use from this code for self
Hedayatullah Hoshmand from Afghanistan country

ALTER proc [dbo].[ExportDatatoExcel]
as
begin
select PName_en as Province,DName_en as District,SName as [School Name],Code,Type,Grade,School.Gender, 

Enrolled_Male,Enrolled_Female,Passed_Male,Passed_Female,
Failed_Male,Failed_Female,PermanentAbsent_Male,PermanentAbsent_Female,
DropOut_Male,DropOut_Female,
CASE HeadMaster_Teachers
	WHEN 1 THEN 'Teacher'
    WHEN 2 THEN 'HeadMaster'
	END AS [HeadMastere & Teachers],
    CASE Teachers_TB.Gender
      WHEN 1 THEN 'Male'
      WHEN 2 THEN 'Female'
	  END AS Gender,
Phd,Master,Bachelors,TED15,TED14,TED12,
Vocational14,Vocational12,RelegiousMadrasa14,RelegiousMadrasa12,Sport14,Sport12,
General12,LowerSecondary,Primaryt,Private,
TeachersTashkeel,Male,Female

from School
join Province on School.ProvinceID=Province.P_ID 
join District on School.DistrictID=District.D_ID 
INNER JOIN Students ON School.S_ID = Students.Student_ID
join Teachers_TB on Teachers_TB.Teacher_ID=School.S_ID
join Tashkeel on Tashkeel.TashkeelID=School.S_ID
 

Order by P_ID,D_ID


end