IF help on statement

Question

Hello Experts, I will like to ask if there's a way to add in a statement if 0 shows will be "success" and if a 1 shows would be "Cancelled" o.IsSkipcartCancelled as 'IsAdminCanceled', this is the line o.IsSkipcartCancelled as 'IsAdminCanceled', o.IsRetailerCancelled as 'IsRetailerCancelled', o.DescriptionOfRetailerCancel as 'OrderStateAtRetailerCancel', (SELECT top 1 ExceptionalEvent FROM JobEvents WHERE OrderId = O.OrderID and EventName = 'close_order') as 'ReasonCode', TRIM(ISNULL(d.FirstName, '') + ' ' + ISNULL(d.LastName, '')) as DriverName, Thanks

Answer 1

Hi @EriK Davila ,

Would you please try the following:

SELECT CASE WHEN o.IsSkipcartCancelled = 0 THEN 'Success' ELSE 'Cancelled' END AS IsAdminCanceled,   
o.IsRetailerCancelled as 'IsRetailerCancelled',   
o.DescriptionOfRetailerCancel as 'OrderStateAtRetailerCancel',   
(SELECT top 1 ExceptionalEvent FROM JobEvents WHERE OrderId = O.OrderID and EventName = 'close_order') as 'ReasonCode',  
TRIM(ISNULL(d.FirstName, '') + ' ' + ISNULL(d.LastName, '')) as DriverName  
 ...  

Hope this helps! Thanks!

Answer 2

Hi @EriK Davila ,

Welcome to Microsoft Q&A!

Glad that you already received your answer.

You could also consider to use IIF function instead of case when.

syntaxsql

IIF( boolean_expression, true_value, false_value )

Please also refer below:

IIF(o.IsSkipcartCancelled = 0 ,'Success' ,'Cancelled') AS IsAdminCanceled,   
 o.IsRetailerCancelled as 'IsRetailerCancelled',   
 o.DescriptionOfRetailerCancel as 'OrderStateAtRetailerCancel',   
 (SELECT top 1 ExceptionalEvent FROM JobEvents WHERE OrderId = O.OrderID and EventName = 'close_order') as 'ReasonCode',  
 TRIM(ISNULL(d.FirstName, '') + ' ' + ISNULL(d.LastName, '')) as DriverName  

If you have any other issue or concern, welcome to post another question in Microsoft Q&A!

Best regards
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.