Hello,
1st, the following condition does not work unfortunately. (call a stored procedure in the where-condition in a coalesce..) and d.bsnr = coalesce(select ag from p_getmaxag(:teilenr,:typ,1),d.bsnr) and d.bsnr < coalesce (select ag from p_getmaxag(:teilenr,:typ,2),100) I have some article, several with worksteps, other without this. For example ArticleA =lamp ArticleB Workstep2= bicycle mill-cut ArticleB Workstep2= bicycle varnish Now I have a stored procedure where I can get the entire stock, input parameter the type (material (no workstep), unfinish products (workstep < the last workstep) = typ2 and finished products (last workstep = typ 3 input parameter) If the input typ = 1, I should get all material, typ = 2 all unfinished products. And this I will write in a sql where condition, preferably without an execute statement. IIF and Case do not work in the condition, neither the procedure call. (p_getmaxag) How can I realize this simply? Thanks in advance Best regards Olaf
