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 |
|
ricky_1605
Starting Member
30 Posts |
 Posted - 2011-04-14 : 01:51:57
|
| Hi guys I am facing a small problem here. A report is generated when the user inputs Year and Month. Now i want the data to come according to the financial year i.e. April to March. The problem is if the user selects February 2011, the total data from April 2010 to January 2011 of a column should be displayed in 1 column and the data of selected month (in this case February 2011) should be displayed in other column. Format as below Column1 Column 2......Selected month (February data)Cumulative (total) (April to January)Nipun Chawla |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-04-14 : 02:02:20
|
please post your table structure, some sample data and expected result
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
query for financial year