Hi Borislav,

Thanks for your attention.

I can't just convert to integer, because I will lost decimals values. So, I just can't find any parameter to replace %i. Take a look a workaround:


Declare @Var1 Integer, @Var2 Numeric (9,3), @Var2i int, @Var2d int
Set @Var1 = 1
Set @Var2 = 123.45
Set @Var2i = Cast(@Var2 As integer)
Set @Var2d = (@Var2 - cast(@Var2 as integer) )*100
RaisError('Var1 = %i Var2 = %i,%i',16,1,@Var1, @Var2i, @Var2d)


But I think it is possible to use numerics as raiserror's parameters. I just don't know how! :-)

Thanks again.