Activity overview
Latest activity by ccupp
Yes, I could do that.. but with 20 tables.. keeping track of 20 Guids is exactly what I was trying to avoid.. If I have to keep track of all 20 Guids.. then I might as well just go through each table and restrict them by hand instead of using a where clause... but i was hoping to avoid that, as I tend to make errors when I copy and paste all those GUIDs around. [image]
casey / comments
Yes, I could do that.. but with 20 tables.. keeping track of 20 Guids is exactly what I was trying to avoid.. If I have to keep track of all 20 Guids.. then I might as well just go through each tab...
DataCompare with a WHERE to only get FK rows of lower tables
I have a database w/ about 20 tables.
There is one table that is basically at the top of the Pyramid.
I want to do a SQL DataCompare where I only get FK rows in child tables..
Lets Assume A is Top ...