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_2512060918115407990 THEN @pMAIN_2512060918115407991 ELSE @pMAIN_2512060918115407992 END | CASE WHEN o.Freight > @pMAIN_2512060918115407993 THEN @pMAIN_2512060918115407994 ELSE @pMAIN_2512060918115407995 END AS Flags,
       CASE WHEN CASE WHEN YEAR(o.OrderDate) = @pMAIN_2512060918115407996 THEN @pMAIN_2512060918115407997 ELSE @pMAIN_2512060918115407998 END | CASE WHEN o.Freight > @pMAIN_2512060918115407999 THEN @pMAIN_251206091811540799_10 ELSE @pMAIN_251206091811540799_11 END & @pMAIN_251206091811540799_12 = @pMAIN_251206091811540799_13 THEN @pMAIN_251206091811540799_14 ELSE @pMAIN_251206091811540799_15 END AS OrderDateFlag,
       CASE WHEN CASE WHEN YEAR(o.OrderDate) = @pMAIN_251206091811540799_16 THEN @pMAIN_251206091811540799_17 ELSE @pMAIN_251206091811540799_18 END | CASE WHEN o.Freight > @pMAIN_251206091811540799_19 THEN @pMAIN_251206091811540799_20 ELSE @pMAIN_251206091811540799_21 END & @pMAIN_251206091811540799_22 = @pMAIN_251206091811540799_23 THEN @pMAIN_251206091811540799_24 ELSE @pMAIN_251206091811540799_25 END AS FreightFlag,
       CASE WHEN CASE WHEN YEAR(o.OrderDate) = @pMAIN_251206091811540799_26 THEN @pMAIN_251206091811540799_27 ELSE @pMAIN_251206091811540799_28 END | CASE WHEN o.Freight > @pMAIN_251206091811540799_29 THEN @pMAIN_251206091811540799_30 ELSE @pMAIN_251206091811540799_31 END & ((@pMAIN_251206091811540799_32 | @pMAIN_251206091811540799_33)) > @pMAIN_251206091811540799_34 THEN @pMAIN_251206091811540799_35 ELSE @pMAIN_251206091811540799_36 END AS CombinedFlag
FROM Orders AS o;


            
        

Parameters (If used)

Query Results: