![]() Temp tables (use as workaround to diff views).Duplicate row sensing (most other answers here do not).See within for the basic template that was based on answer by It supports ![]() Presenting the Cadillac of Diffs as an SP. Which is completely fine for what I need to do. This is basically going to tell me what is in my test data that is not in my real data. At least in my few minutes of testing it seems to work good enough. = NULL)īut I keep getting 0 results back, when I know that there is at least 1 row in td that is not in d. I'm having trouble taking this further though.īased on the answer by I have been trying to use a variation of the following query: SELECT td., td., td.įROM td FULL OUTER JOIN AS d I started by trying something like this: SELECT DISTINCT, , FROM I'm fairly new to SQL and it seems like a lot of the solutions I'm finding are over complicating things. I need to check three pieces of data in doing so, FirstName, LastName and Product. In essence, I want to show all the discrepancies. I want to return all the rows from both tables where data is either in one or the other. I am trying to compare two tables, SQL Server, to verify some data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |