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
>

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