In Stored Procedure, I Have To Select The People Who Got The Salary More Than 30000....

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I have written stored procedure like this...

Create proc SP_Sal_Select
@Designation varchar(20),
@Salary varchar(20)
as
declare @chk as varchar(20)
if exists(select *from Cus_Sal where Salary=@Salary and Designation=@Designation)
set @chk='Software Engineer'
else
set @chk='Non IT'
select @chk

Now i need to select salary>30000 ....
how to write the condition for above code...

Posted 20-Feb-14 17:57pm

M.Thiyagaraja

Add a Solution

Comments

King Fisher 21-Feb-14 0:05am

you want to change this query?
select *from Cus_Sal where Salary=@Salary and Designation=@Designation)
set @chk='Software Engineer'

King Fisher 21-Feb-14 0:06am

select *from Cus_Sal where Salary>@Salary and Designation=@Designation)
set @chk='Software Engineer'

2 solutions

Solution 2

user salary variable seems to be varchar change it to either Money or float
and change if statement

if exists(select *from Cus_Sal where Salary > @Salary and Designation=@Designation)

Posted 20-Feb-14 18:14pm

prakashdotnet

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)

Ni!E$H_WAGH · Accepted Answer · 2014-02-20T18:04:00

Solution 1

try this
replace this

if exists(select *from Cus_Sal where Salary=@Salary and Designation=@Designation)
with this

if exists(select *from Cus_Sal where ~~Salary=@Salary and~~ Designation=@Designation and Salary >30000)

Posted 20-Feb-14 18:04pm

Ni!E$H_WAGH

Updated 20-Feb-14 18:23pm

v3