Problem with the Following Cursor

[vuyiswamb]

Good Afternoon All

I have the Following Cursor

DECLARE VAL_CURSOR CURSOR FOR
SELECT PROPERTY_ID, NEW_MARKET_VALUE, NEW_ATTRIB_CODE, 
ACTUAL_EXTENT, GETDATE() AS STATUS_DATE,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 DATETIME
DECLARE @NEW_EXTENT FLOAT 
DECLARE @VAL_REASON_ID INT
DECLARE @PAR_METHOD_ID INT

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

 
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT VALUATION (PROPERTY_ID,NEW_IMPROVED_VALUE,NEW_ATTRIB_CODE,STATUS_DATE,NEW_EXTENT,VAL_REASON_ID,PAR_METHOD_ID)
VALUES(@PROPERTY_ID, @MARKET_VALUE,@NEW_ATTRIB_CODE,@STATUS_DATE,@NEW_EXTENT,@VAL_REASON_ID,@PAR_METHOD_ID)
 
FETCH NEXT FROM VAL_CURSOR INTO
@PROPERTY_ID, @MARKET_VALUE,@NEW_ATTRIB_CODE,@STATUS_DATE,@NEW_EXTENT,@VAL_REASON_ID,@PAR_METHOD_ID
END
 
CLOSE VAL_CURSOR
DEALLOCATE VAL_CURSOR

when i run it gives me the Following Error

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

What is Wrong

Thanks