Mi store Procedure no funciona

[yesmina]

hola,

tengo problemas con este procedimiento, ya ke cuando no hay ningun registro no genera ningun codigo,aki esta el procedimiento:

CREATE PROC sp_FSopTec_generar_codsol
@codsol varchar(10)OUTPUT
AS
declare @maxsol as int
declare @maxsol2 varchar(10)

SELECT @maxsol=MAX(CAST(SUBSTRING(fst_cod,2,4) AS integer)) +1 FROM FSopTec
set @maxsol2 = convert(varchar(10),@maxsol)

IF @@ROWCOUNT > 0
BEGIN
IF @maxsol=1
SET @codsol='F0001'+'-'+ convert(varchar(20),year(getdate()),100)
IF @maxsol<10
SET @codsol='F000'+ @maxsol2 +'-'+ convert(varchar(20),year(getdate()),100)

IF @maxsol>9 and @maxsol<100
SET @codsol='F00'+ @maxsol2 +'-'+ convert(varchar(20),year(getdate()),100)

IF @maxsol>99 and @maxsol<1000
SET @codsol='F0'+ @maxsol2 +'-'+ convert(varchar(20),year(getdate()),100)

IF @maxsol>9999 and @maxsol<10000
SET @codsol='F'+ @maxsol2 +'-'+ convert(varchar(20),year(getdate()),100)
END
RETURN
GO

Agradecera sus comentarios.

[Andres95]

Que tal asi??

Código:

CREATE PROC dbo.sp_FSopTec_generar_codsol
       @codsol varchar(10)OUTPUT 
AS 
Declare @maxsol as int


Select @MaxSol = 0

SELECT @maxsol=MAX(CAST(SUBSTRING(fst_cod,2,4) AS integer)) 
FROM   FSopTec (nolock)

Select @MaxSol = isnull(@Maxsol, 0) + 1

Select @codsol = right('0000' + convert(varchar(10),@maxsol) + '-', 5) + convert(varchar(20),year(getdate()),100)

Select @codsol = isnull(@codsol, '')
RETURN
GO