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...

This is the logical equivalent of a V/HLOOKUP in Excel. Something like this should work:

DECLARE @SalePrice SMALLMONEY = 250.00;

SELECT MAX(Bonus)

FROM #CompPlan

WHERE HighVal<@SalePrice;

-- sorry, I guess I left one thing...

all dbs not accessed before (or do you mean since) a given date...

Exercise your GoogleFu.

Found this pretty quickly:

http://dinesql.blogspot.com/2010/05/when-was-my-sql-server-database-last.html

I tweaked it a little, but I may have misunderstood the filter you...

Let me see if rephrasing this will help. I'm wondering how to model sales territories when the "borders" move over time.

Same basic sales database (think Contoso DW... it's just less...

I have to admit that I know little about MySQL, but you should be able to use something like this:

WHERE event_time>DATEADD(m,-2,GETDATE())

(subtracts two months from the current date).

one way would be to create a view and then put the aliases there.

CREATE VIEW vw_SomeView

AS

SELECT field1 AS NewName

,field2...