Category Archives: T-SQL

Mystery of the Changing CASE WHEN Output and Data Type Precedence

I was working on a T-SQL query that had some very particular output requirements for decimal places. The problem seemed fairly easy, but when I tried to form a CASE WHEN statement that produced slightly different decimal lengths for each … Continue reading

Posted in T-SQL | Comments Off on Mystery of the Changing CASE WHEN Output and Data Type Precedence