In SQL Server division of 2 integers yields an integer. Try

select @first_year_retention_rate = cast(@no_plan_rowcount as decimal(18,2))/@member_rowcount * 100

print @first_year_retention_rate

>Whats wrong with this.
>
>

>PRINT @no_plan_rowcount  
>

>
>returns 816
>
>

>PRINT @member_rowcount
>

>
>returns 416
>
>

>select @first_year_retention_rate = @no_plan_rowcount/@member_rowcount * 100
>
>PRINT @first_year_retention_rate
>

>
>returns 0
>
>What am I doing wrong .
>
>Thanks