Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2006-09-26 : 10:56:50
|
| Hi, I am trying to display some data via TSQL and can't seem to do it..what I need is this:JAN FEB MAR APR23 12 3 10The numbers represent the number of helpdesk calls logged before each month..( at the beginning of each month )how can I do this ?The fields I have is logdate and closedateI don't want to use and parameters other than Financial Year, so I will end up with a long list of numbers idealy from April 2005 to April 2006.can anybody help me ?thank you |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-09-26 : 11:09:03
|
| Hi jamie, Datename should do it, take a look at BOL. |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-09-26 : 12:44:09
|
| How about some sample data and expected results? Your requirements are also not clearly defined, so explaining a little more detail about what numbers you need and exactly how they should be calculated would help us to help you much easier.- Jeff |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2006-09-27 : 04:51:14
|
| Brett, I can't find what you mean in your sig ?!even without doing the financial year part, how could I just count the calls that were open at the beginning of each month. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-27 : 07:13:33
|
quote:
Originally posted by jamie
Brett, I can't find what you mean in your sig ?!even without doing the financial year part, how could I just count the calls that were open at the beginning of each month.
Please post your table structure, some sample data and the result that you want.
KH |
|
|
|
|
|
|
|
|
calls logged before a time