I know this is going to be easy to all of you, this is my first time performing an if else statement in SQL,
after performing this query:
Collapse | Copy Code
IIf(IsNull(EventSummary.[Event Information - Event Status]),"ACTIVE",EventSummary.[Event Information - Event Status]) AS [Event Status],
I get this error message:
Msg 174, Level 15, State 1, Line 2
The isnull function requires 2 argument(s).
I just want to perform a query that will select the event status, check if it is null, if it is null, then value of event status should be active, else, just copy the value of event status.
I hope you can help me.