MSSQL 증가되는 넘버 생성

SELECT 'C' + CONVERT(VARCHAR(10), GETDATE(), 112) 

+REPLICATE('0', 3 - LEN(ISNULL(MAX(CAST(RIGHT(BOARD_NO, 3) AS INT)), 0)+1)) + CAST(ISNULL(MAX(CAST(RIGHT(BOARD_NO, 3) AS INT)), 0)+1 AS VARCHAR)

FROM 테이블 WITH (nolock) ;