Hi,
I have tested a ado query in the smartobjects-services-tester and it was succesful, but when I copy and paste it to theado query on my graph I get errors. One being that an nvarchar for a column is mean't to be an int and then I convert/ cast it as a int e.g. SELECT CAST(Description AS INT) FROM UserRole but then I get another error Conversion failed when converting the nvarchar value to data type int.
Is there a easier way of doing this?