Tag: EXCEPT

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

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