Case Statement Returning False when Two Columns are Blank when should be True

Transact-SQL
4

hi masond

Hope this helps :slight_smile: :slight_smile:

both the columns must be of the same datatype
when comparing ... to give correct results

to do this
you will have to change the datatype of any one column to the other column

in tsql to do this you have

  1. CAST
  2. CONVERT

example :
legacy.date_closed_c = cast ( current.date_closed_c as timestamp(6) )

https://www.w3schools.com/sql/func_sqlserver_cast.asp

https://www.w3schools.com/sql/func_sqlserver_convert.asp