Interestingly I came up with a similar answer to your first one except using a LEFT JOIN instead of NOT EXISTS, I should have used NOT EXISTS, but when using the LEFT JOIN with TOP 1 ORDER BY A....
A Case for Shorter SQL Server Conference SessionsCommented on: 3 years ago
(March 23, 2012)
I don't think I agree. We can sit through a movie that's 90-120 minutes, why not a technical session of 60 minutes.
The other issue is that, yes, there are times I think a presenter could...
Digital Magazine Archives
Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.
High-quality data is key to uncovering meaningful insights and new opportunities. Melissa Data has recently released a new tool, Data Profiler, to help companies that are dealing with large quantities of data and need a full spectrum of solutions that work....More