求一语句

INSERT INTO t_SubMessage (FInterID,FBrno,FName,FID,FParentID,FTypeID,FSpec) 
select XXX,0 ,fnumber ,left(FModel,30),10036 ,10036 ,' '  
from t_icitem 
where FModel is not null  
 XXX我想取 t_SubMessage表中FInterID最大值递增，如第一条记录就是XXX=FInterID+1 第二条就是XXX=FInterID+2这个语句怎么整？

SQL code

INSERT INTO t_SubMessage (FInterID,FBrno,FName,FID,FParentID,FTypeID,FSpec)  
select row_number() over(order by getdate())+(select max(FInterID) from t_SubMessage)
,0 ,fnumber ,left(FModel,30),10036 ,10036 ,' ' 
from t_icitem where FModel is not null  

row_number()看下