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-10 : 08:44:08
|
| srinivas writes "Dear Sir / Madam, my question is how can i incorporate subtotal,sum,and other mathematical expression in the stored procedure. Actually i have to extract data from excel base on to the SQL Platform.Before transforming i need to incorporate these mathematical expression. Please let me know your options at the earliest." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-03-10 : 08:46:11
|
| SQL contains SUM, AVG, MIN, MAX, COUNT, and some statistical functions. SQL Server also includes the CUBE and ROLLUP operators to provide subtotals and grand totals across groups. The best way to find out if they meet your needs is to look them up in Books Online and follow the examples. |
 |
|
|
|
|
|
SQL - Stored Procedure