In this article, I’ll discuss some of the more frequently used methods for consolidating data from multiple tables into a single result set: SELECT, JOIN, UNION and subqueries.

While the integration of the Power Query engine into Analysis Services Tabular 2017 and Azure Analysis Services with modern data sources will certainly bring a lot of benefits, I think it’s fair to ...

In the screenshot, you can see a query on the rows_with_differences table. This table includes all rows where differences between the two versions were found. For columns that did have changes (such ...

Tables: Compare two tables. Table to Query: Compare a table with the result of an SQL query. Queries: Compare the results of two SQL queries. When comparing the results of two SQL queries, you have ...

In the SQL code, I used fully qualified column names because I’m directly comparing the two tables, not merely using the result set as a passive resource. I’m not returning results from the ...

An interesting Power Query nugget for you: you can compare two tables using the Value.Equals() function. For example, take the following worksheet with five Excel tables on it: The following Power ...

We're going to run this through the paces as I like the idea of free--especially at the cost of Red Gate SQL compare per developer. Even if we only use VS 2013 Express for SQL schema and data ...