thanks crosspatch,

i got to think about this. i didn't consider this possibility yet. I only hesitate because there may be up to 100 sps per module, so that the number...

ok im trying to be a bit more specific. there are modules which run not only one time but 3 or more times. but each one uses the same data...

thanks for your help danW, but in between i found another way to do it:

instead of

select a=1 from ...

now in t-sql

select a = case count(a) when >0 then 1...