Bug with find unused variable and parameters

Ozzie

When I run 'Find Unused Variables and Parameters' you flag @ID as 'The value here is never used.'
DECLARE
@ID INT = ISNULL( ( SELECT MAX( BatchID ) FROM dbo.RDIBatch ), 1 );

DBCC CHECKIDENT ( RDIBatch, RESEED, @ID );

FredericoJ

Hi @Ozzie,

Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6459) to track it.

Best regards,

Frederico