Problem with the Following Cursor

[szlamany]

Put this in a query window and see what prints

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)  -- Note: change datatype here
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_CURSOR

btw - why are you using a CURSOR instead of

INSERT INTO VALUATION SELECT PROPERTY_ID...FROM PROPERTY_MASS WHERE...