Thank you.

This piece of code I have written so far, I want to count only the Round date

where [Has Meds] is equal to only [Has active Meds] (Stand alone).

So from the...

Select Region, Provider, QtrName, sum(cnt_allmed) as AllMed, count(*) as [Not Reconciled in 18 months],

cast(0 as decimal (9,4)) as [% of all Meds not reconciled]---0 as [% of all Meds not...

Thanks so much it worked!!

Yes, it is an integer result, I want to have the average in 2 decimal places.

Thanks,

Haimanti

thanks, but I am getting tons of values after decimal. how to limit that.

Thanks a lot. It worked!!

Select [Quarter Name], Region, [Provider Name],

SUM([Total Visisits Count]) as SumofVisitCounts, sum([100% reconciled]) as [100% Reconciled],

0 as tot_100pervisitscnt, 0 as PercentRecon

into #Final_table

from #SemiFinal_Table

group by [Quarter Name], Region, [Provider...

I am not getting the right results,

even though I modified...the CAST .

I have 0 as PercentRecon (place holder for updating this field) and then

Update #Final_Table ---select...

Sorry, it is not working.

Update #Final_Table ---select * from #Final_Table

SET PercentRecon = (CAST (tot_100pervisitscnt as decimal(8,4))/CAST(sumofvisitCounts as decimal (8,4)))

where sumofvisitCounts>0

giving me the error message

Arithmetic overflow...

Thank you very much. It WORKED!!!

Thank you very much. It works.

Hi,

I tried that but I am getting 3 visits in that case, which is not right, I should be getting only one visit because visit =1 for the same...