You're welcome, Joe.

I understand now and I agree. Server A can start a procedure running on Server B and Server B can pull the data across.

Anyway, you at least know now that you're going to get an error when you divide by zero. To get the behavior you want, you can use...

Just a guess here but have you tried adding this to your OVER clause?

SUM([CY_Quantity]) OVER (PARTITION BY [Customer], [Product], [Year]

...

So you have to try all possible matches and just take the one with the lowest group number?

I made a modification to your table which shouldn't be hard to implement. You have a sequence number attached to some values of Item_Dimension. Put that...

We do something similar, matching on license numbers and names. ...

I hope I'm understanding you correctly. The code below will show you the top 5 amounts in descending order.

There should be no need to cast...

Do you use the name match together with matching on any other columns? Or is match on name only?

Grrrrr.... Good question. My snap judgment was wrong, and in hindsight it's easy to see why. One day I will learn to consider everything ...

Unless he was lying.... 😉

http://www.sqlservercentral.com/Forums/Topic1808839-3740-1.aspx

What do you mean by a "loop back" problem?

If you are looking for the top five total amounts, the code below should work. If you are looking for the top five individual sales, there is no...

Douglas, I hope you realize that just because SQL doesn't provide a function straight out of the box, there is nothing that prevents you from creating user-defined functions that meet...

If you are going to be matching a large number of stores to a large number of customers, you are going to want to create spatial indexes for performance...