Nov 09, 2016 03:02 PM|mardyDacasin|LINK
All your questions will answered here
"The first thoughts are generally one of the following "Since the first value evaluated is numeric, it is converted to decimal, and all other data is expected to be a decimal as well" OR "If SQL Server is able to convert ANY of the values to the specified
type, then all values are expected to be of the converted type". However, that's not correct (although the second is close)!
The real problem is that if you choose to Convert the values anywhere within the Case statement, the datatype you are converting the values to is the expected type of ALL the values regardless of if they are of that type or not. Further, even if NONE of
the values can actually be converted (even if the Convert line of code never executes), ALL of the values are still expected to be of the type specified by the Convert function! "
Dont forget to mark this as answer. Thanks