Posted by Doug on 12/22/05 21:26

I don't think Mr. Guzman's solution will work for the business problem
you are trying to solve. It does allow the index, but you will never be
able to retrieve any of the data where EITHER start OR end time is
null.

I guess I'm trying to understand when a record would be created when
both entries are null?

• Next in forum: Re: dynamically trasnpose rows into columns
• Prev in forum: intead of update/insert trigger on view question
• Thread view: Re: Index on two columns doesn't allow NULL in both - HELP!

[Reply to this message]