December 2008 - Posts

• 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 Y 9 B 3/1/2008 Read More... Posted Monday, December 15, 2008 10:02 AM by mab | 0 Comments Filed under: SQL Server