If all values are integers than integer calculation is used

select @first_year_retention_rate = @no_plan_rowcount*100.0/@member_rowcount

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