|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 7th, 2004, 05:49 AM
|
|||
|
|||
|
Sql Pivot
I am using following statement to get sales of year
Pivot Format(salesdate, 'yyyy') Result Product 2001 2002 2003 A - - - B - - - C now i want to get it for financial year (eg : 01st april 2001 to 31st March 2002). For given period. eg: Product 2001/2002 2002/2003 2003/2004 A B C Can anybody help please.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Sql Pivot |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
