Jorick van der Hoeven - blog

Creating anonymized pseudo-random IDs in T-SQL

snippet

T-SQL

I sometimes need to convert a series of unique sensitive IDs into a list of unique IDs which I can use to share with people who aren’t allowed to know the IDs in the first…

Jorick van der Hoeven

Distinct values in all columns in T-SQL

snippet

T-SQL

A few months ago I became quite frustrated because I had a huge backlog of work to do performing the Quality Control of the analyses of my team members. A large portion of…

Jorick van der Hoeven

Pivoting tables when you don’t know the columns in T-SQL

snippet

T-SQL

Here’s the situation, you’ve got a column in a table which you want to pivot on but you don’t have any control over the distinct number of values that can be in that column.…

Jorick van der Hoeven

First or last in T-SQL

snippet

T-SQL

This of course does not emulate first and last exactly as it doesn’t really allow you to influence the order of the returned fields in the partitioning. It is however very…

Jorick van der Hoeven

Combining strings in T-SQL

snippet

T-SQL

I found out the other day how to solve a problem that had been causing me issues when presenting data. I often got requests to resent data in such a way that we display…

Jorick van der Hoeven

Searching for hidden characters in Excel

snippet

Did you know that you could search for hidden characters and replace with hidden characters in excel?

Jorick van der Hoeven