Not equal to syntax 1

[ashstampede]

I have a store procedure with an if statment, i cant get the not equal comparison in the store procedure.
i have an if statement and try both not equal to operators but it doesn't work/go into the if statement

if @e <> @emp
    set @rt = 0

if @e != @emp
    set @rt = 0

what am i doing wrong

 

[vongrunt]

My first guess is that some of variable(s) are set to NULL.

 

[SQLBill]

What datatype is:

@e
@rt
@emp

As vongrunt says, are any of @emp or @e NULLs? If so, you could use ISNULL to change the NULL to a different value.

SELECT ISNULL(@emp,0)

That will return 0's where there are NULLs in @emp.

-SQLBill

 

[ashstampede]

They are int variables, i will try what you suggested sqlbill

 

[ESquared]

Just keep in mind folks that in some situations you can handle nulls without IsNull by flipflopping the logic.

Here are two examples which demonstrate this:

SELECT
		A,
		B,
		CASE WHEN A<> B THEN 1 ELSE 0 END,
		CASE WHEN A = B THEN 0 ELSE 1 END
	FROM (
		SELECT A=1,B=2 UNION
		SELECT 3,3 UNION
		SELECT Null,4 UNION
		SELECT Null, Null UNION
		SELECT 5, Null
	) X

IF Null <> 1 Print 'Not Equal' ELSE Print 'Equal'
IF Null = 1 Print 'Equal' ELSE Print 'Not Equal'
--Note that the following doesn't work the same as the previous line, because the *entire* condition evaluates to false when there's a null, no matter what, even if you put a NOT in front.
IF NOT (Null = 1) Print 'Not Equal'

-------------------------------------
It is better to have honor than a good reputation.
(Reputation is what other people think about you. Honor is what you know about yourself.)