Mark Brown's Blog

TFS, Visual Studio, SQL Server, BizTalk, SharePoint, .Net, and more ...

December, 2008

  • Mark Brown's Blog

    How to do logic OR AND NOT across rows in SQL

    Scenario You have a normalized table that has values in rows. Let's take an example that has a history table with an approved flag: Date Approved DollarValue Customer 1/1/2008 Y 13.5 A 2/1/2008 N 12 A 3/1/2008 Y 14 A 1/1/2008 Y 11.5 B 2/1/2008...
Page 1 of 1 (1 items)