• starter......

    SELECT TOP 10000

    CustomerID = CAST(Abs(Checksum(Newid()) % 90 + 1) AS INT),

    ProdID = CAST(Abs(Checksum(Newid()) % 900 + 1) AS INT)

    INTO TestData

    FROM sys.all_columns ac1

    CROSS JOIN sys.all_columns ac2

    CROSS JOIN sys.all_columns ac3

    SELECT DISTINCT CustomerID

    FROM TestData

    SELECT DISTINCT ProdID

    FROM TestData

    SELECT COUNT(DISTINCT CustomerID) AS Expr1, COUNT(DISTINCT ProdID) AS Expr2

    FROM TestData

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day