Seriously? You really think it's just fine to open zip files on the internet? Ones that you don't personally know were verified clean before they were posted?

This isn't...

Hi All,

Not sure why you guys are getting offended to unzip a simple .avi file. Anyways i thought of instead of uploading series of screen shots or writing long story...

Hey SSCrazy, your coding is working. Thank you very much, you made my day:-)

select col1,col2, case when col2=0 then '0' else (col1/col2)*100 end [percentage]

from tablename

select grp,sum([amount]) [amount],case when [grp]=1 then 'A01,A02,A03'

when [grp]=2 then 'A22'

else 'A33,A36' end [ledger]

from dbo.sqlcentral

group by grp

-- replace 'dbo.sqlcentral' with your...