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 |
|
ntn104
Posting Yak Master
175 Posts |
 Posted - 2014-02-20 : 08:45:51
|
| I created a webpage that shows result of each quarter sale information....and I want to add sumary row of 4 quarters for the year; How do I write a code to calculate that?The quarter field data format as '02Q08' (02=quarter 2, Q=quarter, 08=year 2008)Thanks, |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2014-03-18 : 06:23:24
|
| Why save the data in that format ? Why not a row for each value ? You can use a gridview and customize the result sets based on the db values, using the object data source. |
 |
|
|
|
|
|
calculate total for each quarter