In my application I am fetching data from a View which internally having multiple select qurries combined using Union. It's near about 500 lines of query.
When i fire Select on view it takes some time and then throws Datatype coversion error. To find the source of the error I execute available queries on View one by one. After that only I come to know which select statement giving me the error.
Could you please tell me best feasible solution to handle such a type of issue?
Thanks in advance.