Best way to sum a recordset..? 1

[kenjoswe]

Hi all,
I retrive records from a SQL database.

What is the best way to sum a recordset?
With rollup? Is there a better way?

/Kent J.

 

[Mighty]

Can you use the SQL "SUM" command to some the required recordset field when you populate the recordset. Mise Le Meas,

Mighty

 

[kenjoswe]

Mighty,

I would like to see both the details and sum of the details.
Like:
Value
10
20
50
30
Sum 110

/Kent J.

 

[Mighty]

I don't know if this is possible but can you do something like:

SELECT ID, VALUE, SUM(VALUE) AS VALUE_SUM FROM mytable Mise Le Meas,

Mighty

 

[Guest_imported]

you can use compute clause or compute by clause in sql server.