how to divide this 2 column and *100 formula

Question

how to divide this 2 column and *100 formula? col 1 1038:07:00 361:38:00 5186:30:00 4712:35:00 2044:55:00 51:00:00 233:47:00 col 2 332:26:00 3938:21:00 4239:13:00 1846:39:00 51:00:00 215:36:00 8:30:00

krunal pande · Answer

Sorry formula is Select (col2/col1)*100 from tblnm

krunal pande · Answer

Select (col1/col2 )/100 from tblnm I use same formula but it gives wrong output. I get result for all column is 100 which is wrong.

Esakki Muthu · Answer

Can you give more details  what exactly you are looking for? Are You mean ? SELECT ((col1/col2) * 100) AS Reuslt from dbo.YourTableName