Bitwise OR operator

SQL Server Query

            
-- Simplified example: Bitwise OR and flag logic without temp tables or updates.  

-- This query directly calculates and displays the flags based on the Orders table.  

SELECT  

    o.OrderID,  

    o.OrderDate,  

    o.Freight,  

    -- Calculate flags directly in the main query.  

    (  

        CASE WHEN YEAR(o.OrderDate) = 1996 THEN 1 ELSE 0 END  

        | CASE WHEN o.Freight > 50 THEN 2 ELSE 0 END  

    ) AS Flags,  

    CASE  

        WHEN (  

            CASE WHEN YEAR(o.OrderDate) = 1996 THEN 1 ELSE 0 END  

            | CASE WHEN o.Freight > 50 THEN 2 ELSE 0 END  

        ) & 1 = 1  

        THEN 'Order in 1996'  

        ELSE 'Order not in 1996'  

    END AS OrderDateFlag,  

    CASE  

        WHEN (  

            CASE WHEN YEAR(o.OrderDate) = 1996 THEN 1 ELSE 0 END  

            | CASE WHEN o.Freight > 50 THEN 2 ELSE 0 END  

        ) & 2 = 2  

        THEN 'Freight > 50'  

        ELSE 'Freight <= 50'  

    END AS FreightFlag,  

    CASE  

        WHEN (  

            CASE WHEN YEAR(o.OrderDate) = 1996 THEN 1 ELSE 0 END  

            | CASE WHEN o.Freight > 50 THEN 2 ELSE 0 END  

        ) & (1 | 2) > 0  

        THEN 'Meets either condition'  

        ELSE 'Meets neither condition'  

    END AS CombinedFlag  

FROM Orders AS o; 

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

 .Select()  

.Columns("o.OrderID","o.OrderDate","o.Freight ")  

.Column(new ColumnArithmatic(new CASE() 

    .When(new YEAR(new Column("o.OrderDate")).Equale(1996))  

    .Then(1).Else(1)).BitwiseOR(new CASE()  

    .When(new Column("o.Freight").GreaterThan(50))  

    .Then(2).Else(0)), "Flags")  

.Column(new CASE().When(new ColumnArithmatic(new CASE().When(new YEAR(new Column("o.OrderDate")).Equale(1996)).Then(1).Else(0)  

    ).BitwiseOR(new CASE().When(new Column("o.Freight").GreaterThan(50)).Then(2).Else(0)).BitwiseAND(1).Equale(1)  

    ).Then("Order in 1996").Else("Order not in 1996"), "OrderDateFlag")  

.Column(new CASE()  

    .When(new ColumnArithmatic(new CASE().When(new YEAR(new Column("o.OrderDate")).Equale(1996)).Then(1).Else(0))  

        .BitwiseOR(new CASE().When(new Column("o.Freight").GreaterThan(2)).Then(2).Else(0))  

        .BitwiseAND(2).Equale(2))  

    .Then("Freight > 50").Else("Freight <= 50"), "FreightFlag")  

.Column(new CASE().When(  

        new ColumnArithmatic(new CASE().When(new YEAR(new Column("o.OrderDate")).Equale(1996)).Then(1).Else(0))  

            .BitwiseOR(new CASE().When(new Column("o.Freight").GreaterThan(50)).Then(2).Else(0))  

            .BitwiseAND(new ColumnArithmatic().StartBracket(1).BitwiseOR(2).EndBracket()).GreaterThan(0)  

    ).Then("Meets either condition").Else("Meets neither condition")  

, "CombinedFlag") 

.From("Orders", "o")  

.Build(); 

            
        

Query build by SqlQueryBuilder

            
SELECT o.OrderID,
       o.OrderDate,
       o.Freight,
       CASE WHEN YEAR(o.OrderDate) = @pMAIN_2507200126442871090 THEN @pMAIN_2507200126442871091 ELSE @pMAIN_2507200126442871092 END | CASE WHEN o.Freight > @pMAIN_2507200126442871093 THEN @pMAIN_2507200126442871094 ELSE @pMAIN_2507200126442871095 END AS Flags,
       CASE WHEN CASE WHEN YEAR(o.OrderDate) = @pMAIN_2507200126442871096 THEN @pMAIN_2507200126442871097 ELSE @pMAIN_2507200126442871098 END | CASE WHEN o.Freight > @pMAIN_2507200126442871099 THEN @pMAIN_250720012644287109_10 ELSE @pMAIN_250720012644287109_11 END & @pMAIN_250720012644287109_12 = @pMAIN_250720012644287109_13 THEN @pMAIN_250720012644287109_14 ELSE @pMAIN_250720012644287109_15 END AS OrderDateFlag,
       CASE WHEN CASE WHEN YEAR(o.OrderDate) = @pMAIN_250720012644287109_16 THEN @pMAIN_250720012644287109_17 ELSE @pMAIN_250720012644287109_18 END | CASE WHEN o.Freight > @pMAIN_250720012644287109_19 THEN @pMAIN_250720012644287109_20 ELSE @pMAIN_250720012644287109_21 END & @pMAIN_250720012644287109_22 = @pMAIN_250720012644287109_23 THEN @pMAIN_250720012644287109_24 ELSE @pMAIN_250720012644287109_25 END AS FreightFlag,
       CASE WHEN CASE WHEN YEAR(o.OrderDate) = @pMAIN_250720012644287109_26 THEN @pMAIN_250720012644287109_27 ELSE @pMAIN_250720012644287109_28 END | CASE WHEN o.Freight > @pMAIN_250720012644287109_29 THEN @pMAIN_250720012644287109_30 ELSE @pMAIN_250720012644287109_31 END & ((@pMAIN_250720012644287109_32 | @pMAIN_250720012644287109_33)) > @pMAIN_250720012644287109_34 THEN @pMAIN_250720012644287109_35 ELSE @pMAIN_250720012644287109_36 END AS CombinedFlag
FROM Orders AS o;


            
        

Parameters (If used)

Query Results: