dwain.c (2/11/2015)

---

In the TOP 2 or 3 or 4 you are listing (outside of the Others group), what do you want to do if there are ties?

This looks to me...

Thanks for replies.

The reason that CTE is not allowed comes from Dundas Dashboard.

I am using the script to create virtual table there. Only Select is allowed, no variable, no CTE,...

Luis Cazares (2/10/2015)

---

Why can't you use CTE/temp tables/variables? That's nonsense, next they're going to tell you that you can't use update or select.:hehe:

The solution should be more like this:

SELECT CASE...

Thanks.

Here is what I come up:

select 'Others' as [Category],

sum(

case when [Category] not in

(

select top 5...

Thanks for reply and sorry for the ambiguous feeling.

Say I have a select query:

Select Category, Sum(Column1)...

Thanks.

The number of output is fixed and won't change in the future.

Thank you guys

Thanks.

Thanks Luis and Scott for the code.

Using Luis code, how do I get a total based on the 12 fields' count result?