It is showing because:
VEHICLES_ORDERS_FW.QUOTE3_SENT_DATE_FW>'01/01/1900' OR VEHICLES_ORDERS_FW.QUOTE3_SENT_DATE_FW IS NULL
You can use ISNULL(QUOTE3_SENT_DATE_FW, SPACE(0)) to get rid of the NULL.
Related blog: How to use COALESCE instead of ISNULL?
Kalman Toth Database & OLAP Architect SQL Server 2014 Design & Programming
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
No comments:
Post a Comment