Monthly Archives: June 2010

FK Constraint error but primary table data exists

Takeaway: Solution is “ORDER BY 1” This is a very deceptive error and spent a few hours working it out. Hopefully this will save some of you some pain. While maintaining and improving performance on some stored procedures, I came … Continue reading

Posted in SQL Server | Leave a comment