Forum Discussion
Solved
“8152 String or binary data would be truncated” error while running select query on a view
I have a complex view (it’s organisational so i cannot paste it here) that joins multiple tables, uses CTEs, performs logical calculations and then provides for multiple columns over which we can sel...
I was able to resolve it by using convert(nvarchar(max), <attributenames>) wherever possible. Made my query slower, but it’s not throwing error at least.
Not sure if this was the right way to resolve though.
I was able to resolve it by using convert(nvarchar(max), <attributenames>) wherever possible. Made my query slower, but it’s not throwing error at least.
Not sure if this was the right way to resolve though.