Hello. I could use some help with understanding why my query returns a partial record set and a conversion error from string "102". SQL Message: -413 Engine code: 335544334
FlameRobin tells me myRecursive_VW has the following columns: - ID Bigint - PAR_ID Bigint - NAME varchar(255) I am using the following test to confirm the ID and PAR_ID are indeed integers. SELECT a.ID+2, a.PAR_ID+2, a.NAME FROM MYRECURSIVE_VW a This test passed. I also created a procedure and have the code run against that instead of my view. Same result. I do not see where the conversion is happening. Any pointers? WITH RECURSIVE myCTEName (id,level,top_key,par_id,name) as ( select id , 0 as level , id as top_key , null as immediate_parent_key, name from myRecursive_VW where par_id is null UNION ALL select chd.id,par.level+1,par.top_key,chd.par_id, name FROM myCTEName par JOIN myRecursive_VW chd ON chd.par_id = par.id ) select * from myCTEName Best regards. [Non-text portions of this message have been removed]
