Databases
StackOverflow2013
Postsdbo
POWHERE NOT EXISTS not working SQL Server 2008
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWHERE NOT EXISTS not working SQL Server 2008
    primarykey
    data
    text
    <p><img src="https://i.stack.imgur.com/LBoyv.jpg" alt="enter image description here"></p> <p>This is a related question to <a href="https://stackoverflow.com/questions/11127684/not-in-query-not-working-sql-server-2008">this</a> but with EXISTS instead of IN</p> <pre><code>SELECT distinct Patient.patientid FROM Patient P JOIN patientICD pICD ON P.patientid = pICD.patientid AND P.admissiondate = pICD.admissiondate AND P.dischargedate = pICD.dischargedate JOIN tblICD ON pICD.primarycode = tblICD.ICD_ID WHERE tblICD.descrip LIKE N'%diabetes%' AND patient.patientID not in ( SELECT distinct Patient.patientid FROM Patient P JOIN patientICD pICD ON P.patientid = pICD.patientid AND P.admissiondate = pICD.admissiondate AND P.dischargedate = pICD.dischargedate JOIN tblICD ON pICD.primarycode = tblICD.ICD_ID WHERE tblICD.icd_id =N'25000' ) </code></pre> <p>This query works fine, but when I try to add another field to the select expressions I have to use <code>WHERE EXISTS</code> and the following query returns 0 results, while the above query returns 130. I'm trying to add the tblicd.icd_id field to the result set from the first query and I'm doing something wrong.</p> <pre><code>SELECT DISTINCT Patient.patientid, tblicd.icd_id FROM Patient INNER JOIN patientICD ON Patient.patientid = patientICD.patientid AND Patient.admissiondate = patientICD.admissiondate AND Patient.dischargedate = patientICD.dischargedate INNER JOIN tblICD ON patientICD.primarycode = tblICD.ICD_ID WHERE tblICD.descrip LIKE N'%TextOfNote%' and not exists ( SELECT DISTINCT Patient.patientid, tblicd.icd_id FROM Patient INNER JOIN patientICD ON Patient.patientid = patientICD.patientid AND Patient.admissiondate = patientICD.admissiondate AND Patient.dischargedate = patientICD.dischargedate INNER JOIN tblICD ON patientICD.primarycode = tblICD.ICD_ID WHERE tblICD.icd_id = N'25000' ) </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USwootscootinboogie
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWHERE NOT EXISTS not working SQL Server 2008
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POWHERE NOT EXISTS not working SQL Server 2008
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload