I recently came up against a pretty big problem with outer joins on SQL Server, and thought I'd talk about it a bit. First let me give you a little background on the problem. <Begin Background> It's common in data warehousing and datamarts to "band" data. By "banding"...