>Thanks Naomi
>
>>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
>>

You're welcome.