Also, if you do the research you will also find the banker's round, also called round to even is used in signal processing as well.

There are numerous articles on...

dont know what to say here.

Ok....

• This reply was modified 5 years, 11 months ago by Sergiy.

sorry about that. Supposed to be copy-paste, something went wrong.

Corrected the article. Should be updated soon.

If it happens on weekend only, then it's most likely an index maintenance job.

or a massive update on a "main" table.

I've got a shorter version of that procedure. No update required.

USE [tempdb];

GO

--==== Remove existing objects
IF (OBJECT_ID('tempdb..#LOANS','u') IS NOT NULL)
BEGIN
DROP TABLE #LOANS;
END;

IF (OBJECT_ID('tempdb..#LOAN_CUSTOMERS','u') IS NOT NULL)
BEGIN
DROP TABLE #LOAN_CUSTOMERS;
END;

IF...

• This reply was modified 5 years, 12 months ago by Sergiy.
• This reply was modified 5 years, 12 months ago by Sergiy.

I prefer not to depend on DATEFIRST settings in my code.

There are several pretty simple techniques to make your code independent of it.

For example, using system variable @@DATEFIRST in your...

Yeah.

Still the future...

No need to pile on for the following but, because of things like this, security breeches in the world just don't surprise me anymore.

https://www.sqlservercentral.com/forums/topic/only-one-expression-can-be-specified-in-the-select-list-when-the-subquery-is-not

How do these people get...

It's funny, the most obvious option of not using lousy Windows interface on...

/shrug I think that the fact that dictionaries are maintained transparently in the internal guts of column store indexes vs having to maintain and join a lookup table by hand...

Thanks Frederico. Cool stuff.

I only made one change to your script:

_____________

Code for TallyGenerator