thank you very much! 🙂

now i think i understand the problem - the first step to resolve it.

sincerely yours

wolfgang

please remember the first posting.

the statements are the same, only the way i call the statements is different.

instead of

SELECT * FROM MyFunktion(ParameterValue1...)

i builded a script like

DECLARE @Param1...

i put the .sqlplan-files in the uploaded zip (a few posts ago)

here is the zip.

plan 1: 0%

plan 2: 93%

plan 3: 2%

plan 4: 2%

plan 5: 2%

i am not allowed to upload .sqlplan-files.

should i change the extension to .txt?

how can i post the execution plan?

ALTER FUNCTION [dbo].[puma_rep_UnterEinheiten](@baseorg int,@welt bit,@nachUmsatz char(1),@transid int,@abschlussmonat int,@mart1 smallint, @mart2 smallint, @mart3 smallint, @mart4 smallint, @konsol smallint,@waeid smallint,@filter int,@wirkung char(1))

RETURNS @report TABLE(child_org_id int,GJ int,hg smallint,summe...

i made a sp but it also took 16 minutes.