I used to work in healthcare, so I totally understand the confidentiality stuff. (Taking the Good Clinical Practices exam after looking at what they were doing nearly gave me a...

What kind of visual are you using for the subreport? Is it a tablix? I would test it by creating a simple tablix and populating it and see if you...

Why can't you use a function?
I'd use DelimitedSplit8K and be done... Why the arbitrary requirement? Is this a class assignment or something?.

Not sure how you would end up with only one record in your subreport.  Are you using a parameterized stored procedure as the source for your subreport's dataset? Does the...

You probably have to shrink it, but then you'll have to rebuild all the indexes... Good thing it's Friday... might be done by Monday.

Did you try using a CASE statement?

If you don't use a date in tabular model, you can't mark the column as a date, so you can't use a lot of the built in time intelligence functions......

A cursor for that is all kinds of overkill. How about a simple not exists subquery?

SELECT *
FROM Employee e
WHERE NOT EXISTS (
                    SELECT s.EmployeeID

(Wait, so you can update directly?)

Found this: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data?view=sql-server-2017

Wouldn't you have to run this on each column?
UPDATE HumanResources.Employee SET EncryptedNationalIDNumber = EncryptByKey(Key_GUID('SSN_Key_01'), NationalIDNumber); 

You mean by querying the sys.all_columns table and using dynamic SQL to automate it?