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 |
|
Joshrinn
Posting Yak Master
118 Posts |
 Posted - 2012-06-07 : 05:37:49
|
| The query that is used for the report, it displays two rows and date as columns. For instance, sept 2011 would have row 1 values and row 2 values. For example row 2 has values for sept as 200, for oct as 210, for nov as 220. I wanted to change the row 2 values meaning the Sept values in row 2 would be now the Oct values and the oct values would be nov values.when I used dateadd, it changed both row 1 and row 2, but I need this change only on row 2. Any help would be appreciated |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-07 : 05:58:56
|
| Can you post the query and what you changed.Difficult to tell what you did from your description.But frrom the title - yes dateadd does work but maybe not as you expect.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-07 : 22:43:05
|
quote:
Originally posted by Joshrinn
The query that is used for the report, it displays two rows and date as columns. For instance, sept 2011 would have row 1 values and row 2 values. For example row 2 has values for sept as 200, for oct as 210, for nov as 220. I wanted to change the row 2 values meaning the Sept values in row 2 would be now the Oct values and the oct values would be nov values.when I used dateadd, it changed both row 1 and row 2, but I need this change only on row 2. Any help would be appreciated
what's the row grouping applied based on which row 1, row 2 etc come?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
Does date add work?