Thanks a lot for clarifying. Now I have to learn more about DTS global variables and dynamic properties task.

I am sorry, I did not get what this script does and how it works in my case. I need to write a query which returns "0" instead of rows...

Sure

And any ideas how to preset the results in the form of matrix? Pivot is not smart in SQL Server 2000.

And how to...

Great, thanks.

Query only lacks GROUP BY clause

For just 2 ProdID the following query also works

select count(a.CustID) from  (select CustID from Orders where ProdID=100) a

join (select CustID from Orders where ProdID=200) b

on a.CustID=b.CustID

But I would like...

Thanks, but it is not what I need.

I'll clarify.

create table Orders (OrderID int identity(1,1), CustID int, ProdID int, Quant int)

insert into Orders (CustID, ProdID, Quant)

values (1, 100, 10)

insert into Orders...