(Kent Milligan) I am running the following SQL statement but getting an error as “Position 1 Null values not allowed in column or variable VC_EST_PAYMENT UPDATE UARSLSDET AS A SET (VC_EST_PAYMENT, FEE) = (SELECT IFNULL(EST_PAYMENT*100,0), IFNULL(FEE*100,0)
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help