Displaying information based on months

I've got to display information based on months. The user provides
The report with a year and then I provide the information for each
Month of that year. I have no idea where to start. Any suggestions on
How to pass the month either in number format or text to a stored
Procedure so that I can retrieve the needed information?
I don't want somebody to do it for me I just want some suggestions on
How to go about doing it.
Thanks in advance for any help.
MathiasCascading Parameters and datepart?
"mathias" <mathias.helbach@.gmail.com> wrote in message
news:1137378113.994027.129370@.g14g2000cwa.googlegroups.com...
> I've got to display information based on months. The user provides
> The report with a year and then I provide the information for each
> Month of that year. I have no idea where to start. Any suggestions on
> How to pass the month either in number format or text to a stored
> Procedure so that I can retrieve the needed information?
> I don't want somebody to do it for me I just want some suggestions on
> How to go about doing it.
> Thanks in advance for any help.
> Mathias
>|||Hi mathias
What i get from you query, you are having year as input, and you want
to display month wise details regarding that year. If it is the case
than i think you should develop ur logic arround group by clause over
month.|||Thanks Techotsav
That works like a charm I had to modify my query slightly but it works.
Thanks
Mathias