Server: Msg 156 1

[monik22]

Here is where the code fails.... Can anyone tell me why

Expiration =
IF Cardholder.Activation = LockAccess.Activation THEN
LockAccess.Activation
ELSE
Cardholder.Activation
END

-----------------------------------------------------Server: Msg 156, Level 15, State 1, Line 10
Incorrect syntax near the keyword 'IF'.
Server: Msg 156, Level 15, State 1, Line 10
Incorrect syntax near the keyword 'THEN'.

 

[vongrunt]

There is no THEN in SQL... Is that part of SELECT statement or something else?

And according to posted code, simple Expiration = Cardholder.Activation looks enough.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[monik22]

Sorry it's > not =
-----------------------------------------------------------
SELECT DISTINCT
Cardholder.LastName,
Badge.EncodedID,
Expiration =
IF Cardholder.Activation > LockAccess.Activation
LockAccess.Activation
ELSE
Cardholder.Activation
END
FROM......

 

[vongrunt]

To correct myself: T-SQL has no IF... THEN. Instead it has CASE WHEN... THEN:

SELECT DISTINCT
Cardholder.LastName,
Badge.EncodedID,
Expiration =
    CASE WHEN Cardholder.Activation > LockAccess.Activation
	THEN LockAccess.Activation
	ELSE Cardholder.Activation
    END
FROM......

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[monik22]

Thanks a lot for your help!!!!!