How is the data entered into the database?

How could I check for both?

Jeff,

I don't understand. The table does allow multiple records to have null values for effectiveEndDT. I am sure there has to be triggers on the table as it is related...

wow i'm an idiot. thanks for your help. to bad there is not some gift card service to give to bulletin board members for good help.

The record should only return 1 result because only one record can have an effectiveenddt null at any given time otherwise there would be lots of errors generated in the...

the team i work for makes using cursors the standard for doing any data manipulation when a lot of simple statements would do. I know I'm complaining. Blah blah.

Here is...