I have a select statement with a WHERE clause filter.
The column in the WHERE statement is a uniqueidentifier. The value is coming as an integer.
So I get this kinda of error
"Operand type clash: uniqueidentifier is incompatible with tinyint"
The incoming value is jsut "176" but it must be "00000000-0000-0000-0000-000000000176"
Is there any way that we can convert the integer to match with unique identifer.
I am sorry that this may be a stupid question. But I just want to know if there is any solution available.
Please share your comments.