I'm working with a table of user input that I'm trying to compare to the current values in the table within SQL.
I'm trying to get the rows where the items are different than what's in the table, but the issue I'm running into is an input value may be 2 when the value in the table is casted as a DECIMAL so the actual value in the table is 2.00. I want to consider those to be the same.
My thought process is that I want to somehow cast my input into the datatype of the column, then compare.
My Table
ColumnName | Value
<user-id> | 1
<user-date> | 2021-06-30T00:00:00
Incoming Values
ColumnName | Value
<user-id> | 1
<user-date> | 2021-06-30