Re: Index on two columns doesn't allow NULL in both - HELP!

On 22 Dec 2005 11:26:28 -0800, Doug wrote:

>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.

Hi Doug,

Not from the indexed view, but you can still get this data from the
table itself.

The view suggested by Dan is intended merely to enforce the constraint,
not to replace the table in queries.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.

Relevant Pages

  • Re: Find Duplicate Data
    ... > Can someone help me to build a query base on: ... All queries above are untested, ... Best, Hugo ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)
  • Re: Index on two columns doesnt allow NULL in both - HELP!
    ... I don't think Mr. Guzman's solution will work for the business problem ... able to retrieve any of the data where EITHER start OR end time is ... both entries are null? ... Prev by Date: ...
    (comp.databases.ms-sqlserver)