Database

DECLARE VAL_CURSOR CURSOR FOR
SELECT PROPERTY_ID, NEW_MARKET_VALUE, NEW_ATTRIB_CODE, 
ACTUAL_EXTENT,11 AS VAL_REASON_ID, 6 AS VAL_METHOD_ID
FROM  PROPERTY_MASS
WHERE NEW =1 

OPEN VAL_CURSOR

DECLARE @PROPERTY_ID INT 
DECLARE @MARKET_VALUE INT
DECLARE @NEW_ATTRIB_CODE VARCHAR(12)
DECLARE @STATUS_DATE VARCHAR(100)
DECLARE @ACTUAL_EXTENT FLOAT 
DECLARE @VAL_REASON_ID INT
DECLARE @PAR_METHOD_ID INT

SET @STATUS_DATE = GETDATE()

FETCH NEXT FROM VAL_CURSOR INTO
@PROPERTY_ID, @MARKET_VALUE,@NEW_ATTRIB_CODE,@STATUS_DATE,@VAL_REASON_ID,@PAR_METHOD_ID

 
WHILE @@FETCH_STATUS = 0
BEGIN

IF ISDATE(@STATUS_DATE)=0 PRINT CAST(@PROPERTY_ID AS CHAR(20))+'"'+@STATUS_DATE+'"'

FETCH NEXT FROM VAL_CURSOR INTO
@PROPERTY_ID, @MARKET_VALUE,@NEW_ATTRIB_CODE,@STATUS_DATE,@VAL_REASON_ID,@PAR_METHOD_ID
END
 
CLOSE VAL_CURSOR
DEALLOCATE VAL_CURSORbtw - why are you using a CURSOR instead of

Msg 16922, Level 16, State 1, Line 26
Cursor Fetch: Implicit conversion from data type datetime to float is not allowed.