Trying to create a conditional split on GUID. As simple as GUID1 != GUID2. According to BOL this is supported:
The expression set, expression1 and expression2, must follow one of these rules:
- GUID. Both expression1 and expression2 must evaluate to the DT_GUID data type.
However, when I do this, I get yhe following message:
(Qoute) The data type "DT_GUID" cannot be used with binary operator "!=".
So, in BOL it's explicitly possible, the error message says not. Of course I can work around it by converting to string, but I need to use this pretty often and would prefer not to convert to string every time. What's the story here?
BTW, I am on 64-bit SQL.
View Complete Post