Skip to navigation
Calculate the percentage with tsql mssql
15.06.17
DECLARE @all float, @pro float,@percent float SET @all = (select count(*) from av0_style) SET @pro = (select count(*) from av0_style where av0_Promotion = 1) SET @percent = (@pro/@all)*100 ; print(@all) print(@pro) print(@percent)
https://en.wikipedia.org/wiki/Transact-SQL
Reply
Anonymous
Information Epoch 1740294283
Using text data files.
Home
Notebook
Contact us
