* while executing this query im getting error. (like varchar cant convert to numberic)
* Here I have no clue in which column it is
* also dont know which row causes it
That error message gives you a strong clue: your source column is varchar() and your destination is numeric(). Start checking datatypes and make sure that they match – or that you explicitly handle the conversions in your source query.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.