Subject How to know the months received?
Author W O
Hello everybody

In a table I have data about money received from the clients. Sometimes a
client pay more than a month, like this:

Client Date(mm/dd/yyyy) Months received
---------------------------------------------
Alice 01/02/2011 2
Alice 03/05/2011 3
Sylvia 01/08/2011 1
Sylvia 02/06/2011 1
Sylvia 03/02/2011 1
Vivian 02/04/2011 1
Zuny 01/10/2011 1
Zuny 03/15/2011 3

And I need to get something like this:

Client Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dic
----------------------------------------------------------------------
Alice Yes Yes Yes Yes Yes
Sylvia Yes Yes Yes
Vivian Yes
Zuny Yes Yes Yes Yes


How I can get it?. I need to write a Stored Procedure or is it possible with
just a select?

Thank you very much.

Walter.


[Non-text portions of this message have been removed]