it displays 0 value in [PER] field or column
SELECT SMC_No, ShareHolderName, CAST(Kita AS FLOAT) / CAST(b.TotKitta AS FLOAT) * 100 AS [PER] FROM vShareHolderName, (SELECT TotKitta FROM vShareCert) b ORDER by SMC_No
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)