In this blog post, you’ll learn more about the Sybase Error Recursive column %1: conversion from ‘%2’ to ‘%3’ loses precision and the reason for receiving this error
Sybase SQL Error Message
Recursive column %1: conversion from ‘%2’ to ‘%3’ loses precision
Reason for this Error
Every column in the recursive subquery must be convertible to the type of the corresponding column in the initial subquery without loss of precision. Try casting the column in the initial subquery to an appropriate type.
