Can't you just group by YEAR(date) counting distinct dates?

I still see that link taking me to an article about Data Compression Double Take which seems different than SQL and T-SQL for Beginners or is that where it...

or LEFT

There are 7 opening brackets '(' but only 6 closing ')'. I think you need to add closing bracket at the end with alias.

Thanks BrownCoat42, and yes we have both of those: 4k unit size and a folder with a lot of files. Also, this server is on receiving end of transactional replication:...

I’m still on 2008 R2 and what I wrote below may no longer apply to later versions, I don't know, but here is what happened to me a few months...

What is the datatype of the date column in your table?

Does "Between 201812 and 201905" means include all days of Dec 2018 and all days of May 2019?

I wonder if grouping is even needed. It looks like one row = one loan. Is this true, komal145? Or there are multiple rows with same loan number but different...

Session level app lock is what came to my mind. It will prevent other sessions to execute SP until it finishes.

Yes, of course,...

Something like this:

INSERT INTO Archive_table (<column_list>)
  SELECT (<column_list>)
  FROM TableA AS A
    INNER JOIN TableB AS B
     ...

Thank you, Jeff, very useful info.

It doesn't persist. Once session is over that specific number can be re-assigned to another session.

Use Convert function. It's in Jeff's example as well.

CONVERT(CHAR(10), <your date here>, 101)

Got it. Thanks Jeff.