Conditional WHERE clause in SQL Server

by

Try this 

SELECT 
    DateAppr,
    TimeAppr,
    TAT,
    LaserLTR,
    Permit,
    LtrPrinter,
    JobName,
    JobNumber,
    JobDesc,
    ActQty,
    (ActQty-LtrPrinted) AS L,
    (ActQty-QtyInserted) AS M,
    ((ActQty-LtrPrinted)-(ActQty-QtyInserted)) AS N
FROM 
    [test].[dbo].[MM]
WHERE 
    DateDropped = 0
    AND (
    (ISNULL(@JobsOnHold, 0) = 1 AND DateAppr >= 0) 
    OR 
    (ISNULL(@JobsOnHold, 0) != 1 AND DateAppr != 0)
    )

You can read more about conditional WHERE here.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. T-SQL split string
  3. Unpivot with column name
  4. How can I get column names from a table in SQL Server?
  5. How can I select the first day of a month in SQL?
  6. Split function equivalent in T-SQL?
  7. Is the NOLOCK (Sql Server hint) bad practice?
  8. Multi-statement Table Valued Function vs Inline Table Valued Function
  9. Select statement to find duplicates on certain fields
  10. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  11. Where value in column containing comma delimited values
  12. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  13. Parse comma-separated string to make IN List of strings in the Where clause
  14. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  15. Compare DATETIME and DATE ignoring time portion
  16. Split function in SQL Server 2008
  17. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  18. SQL “between” not inclusive
  19. Can I set ignore_dup_key on for a primary key?
  20. Using PIVOT in SQL Server 2008
  21. Store multiple bit values in a single table column
  22. Which SQL query is faster? Filter on Join criteria or Where clause?
  23. SQL Server equivalent to MySQL enum data type?
  24. How can I group by date time column without taking time into consideration
  25. Using IF ELSE statement based on Count to execute different Insert statements
  26. When using GETDATE() in many places, is it better to use a variable?
  27. Cumulative Total in MS Sql server [duplicate]
  28. SQL Server SELECT INTO @variable?
  29. Using CASE Statement inside IN Clause
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment