怎么实现这个SQL问题?
| times | number |
| 2006-1 | 5 |
| 2006-2 | 10 |
| 2006-5 | 8 |
| 2006-8 | 16 |
| 2006-12 | 9 |
问题: 上表左列内容不全,1-12个月少了7个月,请用T-SQL语言实现,补全左列内容,补上的左列对应的右列值为0,
上表在数据库中不变.
求问题的代码....
谢谢!
如果还不太清楚请问我.....
谢谢!!!
| times | number |
| 2006-1 | 5 |
| 2006-2 | 10 |
| 2006-5 | 8 |
| 2006-8 | 16 |
| 2006-12 | 9 |
2007-10-14 10:17
2007-10-14 16:10
2007-10-14 16:42
2007-10-14 16:43
2007-10-14 16:46
2007-10-14 17:05
2007-10-14 17:08
2007-10-14 17:08
2007-10-14 17:15
2007-10-14 17:27