If you followed along with last weeks’ post (found here), then the title of today’s post hopefully makes sense. If not, then I would highly recommend reading it (or re-reading it) so that we all can be on the same page. Read it? Great. Let’s get started. Last week I left you with the following…… Continue reading Opposite of a Left Anti Join
Tag: T-SQL
A New Way to Contrast Data
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
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
Wrapping Everything Up Importing and Exporting
When we think of importing and exporting data into SQL Server, whether it be from Excel spreadsheets or some other source, we do have to be careful. If we want to import data into a Production system – this is probably a bad idea period. If proper monitoring is happening on the server, someone will…… Continue reading Wrapping Everything Up Importing and Exporting
More Fun Exporting Data with R
Up until now, we have reviewed getting data out of SQL Server and into Excel. We’ve done it via several means: How to Export data to Excel Have Fun Gathering Data to Excel Using More Tools Even More Fun Exporting Data With PowerShell In today’s post, we’ll go over how to export the data you…… Continue reading More Fun Exporting Data with R
Even More Fun Exporting Data With PowerShell
Earlier, we discussed using PowerShell to import data from a spreadsheet into SQL Server using a method described here. Now, we want to do the exact reverse – export the data from SQL Server to a spreadsheet using PowerShell. As you’ll notice in the linked post, it uses the ImportExcel module. Well, we’re going to…… Continue reading Even More Fun Exporting Data With PowerShell
Have Fun Gathering Data to Excel Using More Tools
In our last blog post – seen here – I showed one way of getting data into an Excel spreadsheet. If you attempted it, you saw how many clicks there. There’s lots of clicking with the wizard. https://www.youtube.com/watch?v=bWq4HR69enc Clickety-clickety Now, let’s try doing it a different way. First, let’s open up the one tool that…… Continue reading Have Fun Gathering Data to Excel Using More Tools
How to Export data to Excel
For the last few posts, I’ve been going on about various ways in which you can import data from spreadsheets into SQL Server. But, why should it only work one way? Why can’t we export data as well? Good question, my friend! One of the ways that you can export data is by using our…… Continue reading How to Export data to Excel