query on sql server, giving true/false values

Question

0.00/5 (No votes)

See more:

suppose I have the following code:

SQL

select employer_id
from employer_tb

I want this code to give me a true/false value.
false if employer_id is empty, otherwise it should give a true value.
someone please show me how?

Posted 7-Nov-12 23:26pm

Member 9160577

Updated 7-Nov-12 23:28pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-Nov-12 5:37am

Do you want to check for one particular employer_id, whether it exists in the table or not, right ?
Or what you exactly want to show ?

faisal23 8-Nov-12 5:39am

I think you have to check whether particular id is present or not. In this condition use
select * from employer_tb where emplyer_id=......

2 solutions

Solution 2

You will have to provide the parameter value for @employer_id

SQL

IF (select count(*) from   employer_tb   where employer_id = @employer_id)=1
BEGIN    PRINT 'true' END
ELSE 
BEGIN    PRINT 'false' END

If in your logic an employee id can appear more than once, modify the code above as:

(select count(*) from   employer_tb   where employer_id = @employer_id)>=1

Hope this helps

Posted 8-Nov-12 0:43am

Eyakem

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)

Om Prakash Pant · Accepted Answer · 2012-11-07T23:57:00

Solution 1

you can do this with case statement:

SQL

SELECT   Employer =
      CASE employer_id
         WHEN '' THEN 'true'
         ELSE 'false'
      END
from employer_tb

this assums that data is '' and not null.

Posted 7-Nov-12 23:57pm

Om Prakash Pant

Comments

Baji Jabbar 8-Nov-12 6:00am

Good call!

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-Nov-12 6:26am

I guess OP wants false, when employer_id is empty.
But you have written as true.

Om Prakash Pant 8-Nov-12 7:03am

yes, it has to be the other way

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-Nov-12 7:15am

Then please change your code.
Thanks...