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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-22 : 17:01:42
|
lynda chemlal writes "Hello team, I want to extract data from a table for a report, these data are for a period of time grouped by month. How can I get the months with no data with zero as value ? ex: I get JAN-01 1 17 13 MAR-01 0 25 2 I need this : ( for further use and customer need ) JAN-01 1 17 13 FEB-01 0 0 0 MAR-01 0 25 2 Thanks" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-01-22 : 17:54:30
|
| You'll need to create a table of months and then perform a join - how about giving us the query as it is, and we can modify it?I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
month display in a query