Last post Nov 04, 2020 12:02 PM by mgebhard
Nov 04, 2020 04:57 AM|jagjit saini|LINK
On below line u get above error
Nov 04, 2020 12:02 PM|mgebhard|LINK
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.