What is your reason for using NOLOCK? You know the implications of it, right?

Why with a SQL SP? Would you consider using SSIS instead?

Please don't call me "bro", with respect, we aren't that familiar.

As for your data types, as I said, declare them as what they are; you said yourself that...

Also, just noticed that @dob_date is an nvarchar as well. If it's a date, it's should be declared as so.

What is your question?

Also, you're declaring your parameters @DOLA and @GI as nvarchars, but then comparing them to integers. Why? If someone passes a non-numeric value to these,...

Could you define more complicated/flexible? I've found SSRS to be quite flexible, so it would be good to know what your aim is and why you're struggling.

We have a SQL Server 2017 and Windows Server 2016 Evaluation VM, which I'm just doing some benchmarking on now. I'll then be patching it and seeing where those same...

Microsoft released a guide on how to do this. A quick Google will find it for you. You can't achieve this without adding the Linux machine to your...