ORDER BY DATE showing NULLS first then most recent dates

by

@Chris, you almost have it.

ORDER BY (CASE WHEN [Submission Date] IS NULL THEN 1 ELSE 0 END) DESC, 
         [Submission Date] DESC

[Edit: #Eppz asked me to tweak the code above as currently shown]

I personally prefer this a lot better than creating “magic numbers”. Magic numbers are almost always a problem waiting to happen.

More Related Contents:

  1. Check if table exists in SQL Server
  2. How do I generate a random number for each row in a T-SQL select?
  3. Find index of last occurrence of a sub-string using T-SQL
  4. Regular Expressions in SQL Server servers?
  5. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  6. How can I insert binary file data into a binary SQL field using a simple insert statement?
  7. Joining tables from different servers
  8. Restore a SQL Server 2000 backup on SQL Server 2012
  9. How to execute SSIS package when a file is arrived at folder
  10. INSERT INTO @TABLE EXEC @query with SQL Server 2000
  11. How to create jobs in SQL Server Express edition
  12. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  13. How to delete large data of table in SQL without log?
  14. Insert Update trigger how to determine if insert or update
  15. What is the best way to truncate a date in SQL Server?
  16. Do I really need to use “SET XACT_ABORT ON”?
  17. What is a Trusted Connection?
  18. Understanding SQL Server LOCKS on SELECT queries
  19. Handling date in SQL Server
  20. How to get difference of days/months/years (datediff) between two dates?
  21. How to convert number of minutes to hh:mm format in TSQL?
  22. Dynamically assign filename to excel connection string
  23. SQL Server Group by Count of DateTime Per Hour?
  24. Temporarily disable all foreign key constraints
  25. How to import a DBF file in SQL Server
  26. SQL Server Dependencies
  27. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  28. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  29. Date range overlapping check constraint
  30. To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher

Leave a Comment