Click here to Skip to main content
14,936,800 members

Articles by S Douglas (Tip/Trick: 1)

Tip/Trick: 1

RSS Feed

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 2.00

Database Development
SQL Server
Posted: 26 Aug 2011   Updated: 26 Aug 2011   Views: 8,781   Rating: 2.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
Another way of getting totals, whether it be by group or set is to use the CUBE and ROLLUP predicates.By group (each grouping of FIELD_DESCRIPTION will have a total sum):SELECT FIELD_DESCRIPTION , SUM(FIELD_VALUE)FROM tbl_DataGROUP BY FIELD_DESCRIPTIONWITH CUBEOr:By Cube...

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

S Douglas
Database Developer
United States United States
Just another hack, who manages to take care of issues that would otherwise go unsolved. Smile | :)