Yes I understand.  I will follow the procedure going forward.  Let me go over his post today and familiarize myself with it before proceeding.  Thanks guys!

Jeffrey:

Thanks for your patience.  I will review the procedures for posting questions and the code you submitted to help me.  About the joining ID to ID...I guess I wanted to...

I am new to this and appreciate the help.  Of course I would like to provide whatever I can.   The only thing I did to this point was join the...

I cant provide anything specific to tables for sensitivity reasons but can explain in detail below.

TABLE1 has Y for Year and M for Month.  It also is the main table...

Your suggestion worked.  Thanks.  I am just getting the hang of this but will post the working formula even though there is probably a better way to do this.

CONVERT(DECIMAL (10,2),100...

I think it is close.  This formula gives me the correct format but now anything past the decimal is 0.  How do I convert this formula to show the numbers...

I understand kinda what you are saying but it looks like i am not doing it right because I am getting an error now.

(CAST(ABC/XYZ) as decimal(10,2)) as "PERCENT2"

thanks so much to both of you.  the last formula worked for me and I appreciate you both taking the time to help me.  cheers!

select CAST(ROUND(COLUMN_A*100.0/(CASE WHEN COLUMN_B = 0 then -1 ELSE COLUMN_B END) as decimal(5,2)) as "Percentage" from TABLE

I think this is the one I need but I am getting a syntax...

thanks so much for the fast reply.  I will try all of your solutions then post which one worked for me.  much appreciated.