Search code examples
sqlsql-server-2008-express

Added new field to table and to stored procedure, now procedure returns no results

I recently added a Deleted column to my table and then wanted to add an additional where clause but now I'm not getting any results anymore (it returned results before I added the deleted column)

SELECT 
    tblEquipment.*, tblUsers.* 
FROM 
    tblEquipment 
INNER JOIN 
    tblUsers ON tblEquipment.UserID = tblUsers.ID 
WHERE  
    (UPPER(tblUsers.Dept) = 'ASPIRE' OR UPPER(tblUsers.Dept) = 'DEVELOPMENT') 
    AND (AssetType = 'WORKSTATION' OR AssetType = 'LAPTOP') 
    AND (tblEquipment.Deleted != 1)  
ORDER BY 
    Username

thanks for any help

Solution

  • If Deleted is NULL for every record, your condition should be:

    AND (tblEquipment.Deleted != 1 OR tblEquipment.Deleted IS NULL)