Sybase Error – Recursive column %1: conversion from ‘%2’ to ‘%3’ loses precision

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.