Heh... this happens during meetings, as well.  Someone goes off on a tangent or with some really...

Sorry... post removed.  Apparently I replied on the wrong thread.

Thank you for the feedback.  Since you're the one that will need to support it, at least in the short term, do you understand how and why...

And now, how to put the brakes on a migration project...

Break your wrist on a bicycle ride so you only have one hand to type with and...

Thank you, Jeff !

Studying your sp_ShowWorst today. Pretty amazing so far.

I will definitely share a couple of  SPs in same 'LOB' as your that I have written recently.

Starting to...

Sorry... post removed.  Apparently, I posted to the wrong thread.

• This reply was modified 5 years, 10 months ago by Jeff Moden.

Good lord... I had to work through all of that with...

Sorry - since I don't have those tables or any sample data I wasn't able to validate the code.  I missed the closing parenthesis on the sum...

            
June 15, 2020 at 1:24 pm
            
#3763124

            
            
                                                
        

<quote>From the Last Sentence of the Conclusion in the Article...

To maintain the best precision of the final result all intermediate calculations must be performed on numbers in floating point formats,...

Ya know... If you were to post an actual CREATE TABLE bit of code for the pertinent columns for this problem...

I have to ask... were the databases previously on-premise?  If so, did they "work fine"?

Perhaps the author should spend a bit more time on it first.

Msg 8152, Level 16, State 13, Line 1

String or binary data would be...

Just like the best managers, "GateKeepers" must not be just enforcers... they must also be "servant-providers".   That doesn't mean they should just rollover and give in just because someone wants...

😀  Thanks for the feedback.

To be sure, though, do you understand how and why it works?

Heh... it's a part of EVERYTHING...