Conversion failed when converting the varchar value 'Grand Total' to data type int.

Question

User1979860870 posted

Hi

  On below line u get above error

Coalesce(UniqueId,convert(varchar(20),'Grand Total'))

Thanks

Answer 1

User475983607 posted

If UniqueId is an integer then your code tries to place a VARCHAR() in an INT column.

Coalesce(convert(varchar(20), UniqueId), convert(varchar(20),[Grand Total]))

The 'Grand Total' looks suspicious too.  Unfortunately, you did not share all the relevant code so we can only guess.