× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. September 2008

RE: SQL for distinction between not valid and not there

Pete,
Coalesce will not work for me in that if I look for a row for
product #1 and store #1 it will not be found so a null row is returned
(but this is good because there are no rows for product #1) but if I
look for product #11 and store #1 I also get a null row returned (many
rows for product #11). I just cannot get my mind around away to code
this.


Eric,
In my mind I personally do not like the way the data is describe
but at the moment the change I am making does not lead in the direction
to alter the application where I am getting the data from. Anything
short of a specific store and product causes me problems. (In my case,
however, it would be PRODUCT, *ALL for all stores can receive this
product.)

Thanks, Matt

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.