Search results

I have a field on which I like to perform some data validation before the record is saved (regardless of either it's an new or existing record). The logic is this: If Closed is not null, then resolution and notified must not be null (have zero length protection at table level). My code is as...

I have a table that tracks a series of (mostly) date-based events and I'm trying to decide whether to further normalise the table. The process works like this: 1. We are notfied of a problem (PBTCID PK, PropertyID FK, DatePBTC) 2. We send a recorded letter (DateRecLet) 3. We send a 1st class...

I've looked at so many options for writing this query that I can't see the forest for the trees and hoping you kind folks will point me in the right direction. I have a table called services that includes: service_id prop_id service_year (ie: 2007, 2008) service_date (ie: 3/3/08) service_id...