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 - 2006-03-02 : 08:04:12
|
| raja writes "That Date stored in the table isOrderNo OrderDate qty1 12/12/2005 452 02/01/2005 233 12/01/2005 644 04/02/2005 23i need monthly wise comparsion and get output like thisDec 2005-Jan 2006 -42Jan 2006-Feb 2006 64can anyone help me" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-03-02 : 08:04:57
|
| Not with the sample data you provided, it does not match the date ranges you've specified in the output. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
SQL Query