• CELKO (12/6/2016)


    I hope that “is_active” is not a bit flag; that would mean you are using assembly language programming in SQL and we do not do that.

    Not that means that he is using the tools at hand. How many times do you have to be reminded that T-SQL does not support the Boolean data type that ANSI SQL recommends in place of the bit flag?

    If you don't like people using a bit flag in T-SQL complain to MS about the lack of a Boolean data type. Until they implement it you have no basis to complain about people using a bit flag.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA