Question : I have one table that holds payment data. I’d like to insert orders that ended in a declined […]
Tag: except
Selecting values that are not associated with one side of a many to many relationship
Question : I have a junction table between categories and values that indicate which categories are associated with which each […]
How do I use SSMS to compare Database 1 Table 1 against Database 2 Table 1?
Question : I have two databases – Database1 and Database2. Both databases contain a table that has similar structure, exemplified […]
EXCEPT operator query to differentiate between new and changed rows
Question : I am using the EXCEPT Operator to compare data between two tables (as part of a final import […]
What is most efficient way to compare two large result sets in SQL Server 2012
Question : Current advice for the most efficient way to compare two large result/row sets seems to be to use […]
Contained DB Collation error
Question : When changing a database to partially contained I am getting the following error: Cannot resolve the collation conflict […]
WITH … AS statement not working as expected
Question : I get this error: It arises when I try to execute the following query: with expensive_service as ( […]
How to compare data between staging and operational tables?
Question : I just want to ask how to compare two database tables, staging vs. operational tables. After we did […]
An efficient way to compare two large data sets in SQL
Question : Currently, I’m comparing two data sets, that contain unique StoreKey/ProductKey combinations. The 1st data set has the unique […]
ORA-00907: missing right parenthesis on query with subqueries and EXCEPT operator
Question : I am getting ORA-00907: missing right parenthesis for the following query: SELECT PEOPLE.NAME FROM CLIENTS K INNER JOIN […]