That's so so so cool 🙂

Even though it's trivial to reverse with a PRINT CAST(@_ AS NVARCHAR(MAX))

Still I love it. Moreover I can now play pranks on my dev friends...

My goal WITH ENCRYPTION is not so much to "secure" our code base.

It's the same as with .NET or Java code.

Just some decent obfuscation.

But, obfuscation is good enough to prevent...

I never liked solutions with precomputed data, but it seems that performance should take priority over my taste 🙂

How do you fill in the calendar table?

Fill it once in advance...

The issue of working days is much larger than just weekends.

There are national holidays as well, plus unexpected "holidays" like extreme weather conditions and such.

In our app we have separate...

Yeah, you are right, thanks 🙂

The '*' is killing you. Use '%' instead.

If you want to search for text that for example contains % or other special characters you have to escape them.

See the example...

Wouldn't something like that do the trick?

DECLARE @OrderbyProcessId int, @OrderByActionKindId int, @OrderByActionDetailId int

SET @OrderbyProcessId = 1 -- ASC

SET @OrderByActionKindId = 0 -- No Order

SET @OrderByActionDetailId = -1 -- DESC

SELECT ProcessId,...