Subject | How to know the months received? |
---|---|
Author | W O |
Post date | 2011-09-19T05:22:42Z |
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]
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]