If you’ve been following along with the previous blog posts, you’ll know I like to show different ways to get the same data. With last week’s post on how to find where two tables differ – found here – you know that this week we’re going to see another way of seeing what is shown…… Continue reading A New Way to Contrast Data
Month: July 2021
Ways to Contrast Data
As you have probably determined, with blog posts like these: Ways to Compare DataDifferent Way to Compare Data You know when the word compare is used, sooner or later the opposite is going to be used. Yes, folks – this week we are going to be talking about contrasting data. SELECT * FROM dbo.Person1 EXCEPT…… Continue reading Ways to Contrast Data
A Different Way to Compare Data
Last week, we discussed the INTERSECT operator and how it is a great way to show what data points are the same between two disparate sources. INTERSECT in diagram form As with most operators in SQL Server, there is another way to get the same data. It’s one that many of you are familiar with…… Continue reading A Different Way to Compare Data
Ways to Compare Data
Today’s one of my favorite days – the day we start a new series of posts to help people out with their data! This week, I want to talk about one of the many things that people have asked me to do for them because they think it’s just too hard. This week, I want…… Continue reading Ways to Compare Data