I need a stored procedure to help me summarize the notes for my daily timeslips. In the database table I record each of my timeslips. Sometimes a client will have several transactions in one day. I want to concatenate all of the notes for one day in one record in the result set. The stored procedure will have two parameters (StartDate and EndDate) These parameters need to be of type SmallDateTime. I have attached a sample of my datatable and my required result set.
## Deliverables
1. Stored procedure with comments that I can run in query analyzer to return my dataset.
## Platform
Microsoft SQL Server 2000