• as we have nothing to base code on...then here is a very simple view to get you started

    SELECT TOP 1000

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

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

    TransDate = Dateadd(dd, Abs(Checksum(Newid()))%Datediff(dd, '2013-05-01', getdate()), '2013-05-01')

    INTO #D

    FROM sys.all_columns ac1

    CROSS JOIN sys.all_columns ac2

    CROSS JOIN sys.all_columns ac3

    SELECT CustomerID

    FROM #D

    WHERE (TransDate > GETDATE() - 32)

    GROUP BY CustomerID

    HAVING (COUNT(ProvID) > 1)

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