SQL Code i3

In Part 1, we looked at some fairly typical examples of using CROSS APPLY. But the best is yet to come. Consider this problem that Adam ...

In most SQL Server books or tutorials, the APPLY operator would get no more than a 1 or 2 page treatment, if at all. (A notable exception ...

In moving from the Visual FoxPro (VFP) world to the SQL Server world, the biggest thing that I had to un-learn was the concept of a “natura...