Another day another “how have I never come across this problem before”. So todays challenge is to essentially execute a stored procedure which will allow us to alternate a BIT value. So if the value is 0 make it 1, if it is 1 make it 0.
After a little goggling it seems utilising the Bitwise XOR operator is the best method.
While i’m not the best person to preach about the benefits of using this operator it got the job done in this instance, for more information start here: