I have not seen it, but I've watched some of his presentations. He knows his stuff, for sure. There aren't many SQL Server Masters, and he is one -...

I agree. Cool solution Eirikur... I just cheated on the ASCII part... and ROW_NUMBER() was a handy surrogate.

Why the "not using ROW_NUMBER()" restriction? It works!!

Table scripts:

CREATE TABLE A (num1 TINYINT PRIMARY KEY);

GO

INSERT INTO A(num1) VALUES (1),(2),(3),(4),(5);

CREATE TABLE B(ltr CHAR PRIMARY KEY);

GO

INSERT INTO B(ltr) VALUES('a'),('b'),('c');

SQL:

SELECT num1, x.ltr...

Since you're new, we'll try to be gentle... no guarantees though. Help yourself by reading Jeff's article "Forum Etiquette: How to post data/code on a forum to get the...

To do what you want, you need a Calendar table with all the Months/Years you want, and then outer join that to your Invoices table.

Something like...

SELECT c.Year, c.MonthNumber, SUM(i.InvoiceAmount) AS...

Try using DelimitedSplit8K.

Read this article:http://www.sqlservercentral.com/articles/Tally+Table/72993/

Folks here help people, they don't usually do their work for them. So show us what you tried...

Your data is contradictory. A vehicle is moving whenever Speed>0, but your data says that it's not moving unless speed>1.

If you have SQL Server 2012 or later this can...

Yes to all three.

The confusing part for me was how to compare a group of sales from one year to another year when the territory definitions are changing. (So that...

Jeff,

Oh, I think I get it now... So each time a customer got assigned to a different territory, then I would have to create a new record for that customer...

I would look around for Jeff Moden's article(s) on hierarchies. Not sure if he uses a CTE or not.

The code helps some, but a table definition (create table script) for the table the data is in would help a lot. (and some sample data).

On to the question...

If you want to group the non-top 5 into one group, then you could do it in T-SQL and then create your report based on that.

Here's a quick sample (sorry,...

Something is odd here. How are you creating your grand totals?

Can you post a report with dummy data, so we can recreate the problem?

I've just never heard of totals...

Re-reading this... Welcome!

Those are ROWS, thank goodness! Across columns is NOT fun. Best way is to post consumable data...

This looks like it works:

SELECT P.Id, P.Price, P.CurType,...

A simplified version of your...