No worries. Scott's solution should work for you.

I have not taken the time to analyse your code, but I would suggest leaving the pivoting to SSRS. If you can get results in the form

Username, DBName, Roles

(where Roles...

I often use this site when looking at JSON strings. I pasted your J1 version into it and, as you will see from the image below, it is perfectly...

What is the datatype of the Input variable? If numeric, the values 1.1, 1.10 and 1.100 are indistinguishable.

I suggest you consider writing a stored procedure, with parameters, to return your desired dataset. This sort of thing:

CREATE PROCEDURE dbo.GetSomeData @StartDate DATE, @EndDate DATE
AS
SELECT t.c1, t.c2
FROM...

Your final WHERE clause makes no sense:

WHERE BusinessEntityID >= @BusinessEntityId AND BusinessEntityID <= @BusinessEntityId;

This is equivalent to

WHERE BusinessEntityID = @BusinessEntityId

Is that what you meant?

As you're on 2019, use the TRIM() function instead. Do the trim first.

LEFT(TRIM())

If this works, it's a bit simpler. Can't remember how SSIS handles NULL values in expressions like this, so might not work.

replace(FirstName + " " + ...

Hashing is a one-way process ... you can't get back to the original value if you know only its hashed value.

Thanks for the reply, Phil! I think I could handle a simple query like that as well. Where it starts getting rough for me is when there are [x]...

varchar cause there are letter in it ...

Wow, I can see why your life is miserable! 🙂

I believe that I could do it in SQL, but it would take a significant amount of effort.

If you were to...

• This reply was modified 3 years, 7 months ago by Phil Parkin.

You've been here long enough to know about providing your sample data in a form which can be pasted into SSMS (with relevant CREATE TABLE and INSERT statements), rather than...

What is the datatype of the column 'status_count'?

We have assumed that it is an integer, but I suspect that it is not.

What happens when only one of the columns has an image?