I had noticed the same thing yesterday.  I send Steve and WebMaster@SQLServerCentral.com and email outlining the symptoms.  Steve emailed me that a ticket has been opened and the right folks...

hmm.. for some reason it says that the last post by me but I can't see it

UPDATE: weird.. I could see only 3 pages and once I posted...

Oops, my bad, I am posting again new spread sheet to clarify

Please have a look at it now, if its better explained now , however if there are more...

And, usually slower. I haven't tested...

So, enquiring minds want to know... did that latest code help?

My guess would be that it cannot be YYYYDDD because the first D is always a 0.  Perhaps YYYYoWW but why the bloody zero?

Now, if we could just get mcfarlandparkway...

The only reason I didn't use STUFF is because if you DO use the code on data that has already been modified by the use of STUFF, then it's going...

Another good link can be found here.

https://www.sqlshack.com/introduction-to-row-level-security-in-sql-server/

Back in the 80's, I was teaching people how to use these new fangled things called "PC's".  We had Lotus 123 and WordPerfect.  I had quickly become one of the...

Ok... first of all, I STRONGLY recommend NOT using the (ugh!) severely performance challenged FORMAT function! 😀

After that, the following will do the trick and "forgive" original formatting mistakes like...

Is it really a number...

With that, I'll ask, are you really saying that you want to restrict the two users from seeing each other's products at any time and not just for the code...

I quit smoking on the 29th of April, 2021 at 5:ooPM and haven't had a puff since.  Having done such a thing a couple of times in my life for...

Work-wise, 2021 was a big win for me. I changed jobs from being an everything DBA & developer at a medium sized company to being a production DBA in...

As a bit of a sidebar, the 40 day thing isn't correct for things like the Moderna booster, which requires you to wait for 6 months before getting it.  I...