Viewing 15 posts - 271 through 285 (of 4,080 total)
I understand now and I agree. Server A can start a procedure running on Server B and Server B can pull the data across.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2016 at 9:03 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2016 at 8:50 pm
Just a guess here but have you tried adding this to your OVER clause?
SUM([CY_Quantity]) OVER (PARTITION BY [Customer], [Product], [Year]
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2016 at 5:40 pm
So you have to try all possible matches and just take the one with the lowest group number?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2016 at 1:02 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2016 at 12:51 pm
koti.raavi (9/5/2016)
Yeah i do match on both member Id and name as well.My case member id is not unique
Thanks,
Dhana
We do something similar, matching on license numbers and names. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2016 at 11:45 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2016 at 11:34 am
Do you use the name match together with matching on any other columns? Or is match on name only?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2016 at 8:17 am
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 ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 4, 2016 at 7:14 pm
Unless he was lying.... 😉
http://www.sqlservercentral.com/Forums/Topic1808839-3740-1.aspx
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 4, 2016 at 7:07 pm
What do you mean by a "loop back" problem?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 4, 2016 at 9:00 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 4, 2016 at 8:52 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 3, 2016 at 7:19 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 2, 2016 at 4:35 pm
SQL naturally favors the clustered index.
As a general rule it favors the most efficient index.
My environment is similar to Chris' database. We have some very wide tables, and...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 2, 2016 at 2:58 pm
Viewing 15 posts - 271 through 285 (of 4,080 total)