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