SQl CASE Statement

by

Something like..

ORDER BY 
  CASE 
    WHEN ISDATE(DateTime) = 1 THEN 
    CASE DateTime
       WHEN <= '2016-03-01' THEN 1   -- Preseason
       WHEN >= '2016-03-31' THEN 3   -- PostSeason
       ELSE 2 END                    -- Season
   ELSE 4 END,                       -- Not a date, figure out how to handle
  DateTime

More Related Contents:

  1. How to calculate age in T-SQL with years, months, and days
  2. Levenshtein distance in T-SQL
  3. Convert multiple rows into one with comma as separator [duplicate]
  4. How to get sp_executesql result into a variable?
  5. How can I use optional parameters in a T-SQL stored procedure?
  6. Select query to remove non-numeric characters
  7. T-SQL Decimal Division Accuracy
  8. Selecting a Record With MAX Value
  9. T-SQL: Selecting rows to delete via joins
  10. T-SQL Pivot? Possibility of creating table columns from row values
  11. What is a “batch”, and why is GO used?
  12. TSQL divide by zero encountered despite no columns containing 0
  13. T-SQL loop over query results
  14. How to Round a Time in T-SQL
  15. How to convert a “dd/mm/yyyy” string to datetime in SQL Server?
  16. t-sql get all dates between 2 dates [duplicate]
  17. Return a value if no rows are found in Microsoft tSQL
  18. How to pivot table with T-SQL?
  19. Using Aliases in Where Clause or an Alternative Option?
  20. Testing for inequality in T-SQL
  21. Can I use the MERGE statement in SQL Server 2005?
  22. Replace a newline in TSQL
  23. T-SQL – function with default parameters
  24. How to use an Alias in a Calculation for Another Field
  25. Check if a varchar is a number (T-SQL)
  26. Using a cursor with dynamic SQL in a stored procedure
  27. T-SQL Between Dates Confusion
  28. Poor Man’s SQL Pivot. List Questions as Columns and Answers per User in one row
  29. How to parse string into date?
  30. Stored procedure hangs seemingly without explanation

Leave a Comment