0

## Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

``````DECLARE @troopstrength INT = 75600
DECLARE @troopbonushealth INT = 234
DECLARE @troopbonusstrength REAL = 254
DECLARE @troopbonusstrength2 INT = 592
DECLARE @troopnumber INT = 79
DECLARE @aydaelevel INT = 0

DECLARE @enemy1strength INT = 2600
DECLARE @enemy1number INT   = 3800
--DECLARE @enemy1strength INT = 1100
--DECLARE @enemy1number INT   = 8100

DECLARE @enemy2strength INT = 100
DECLARE @enemy2number INT   = 42000
--DECLARE @enemy2strength INT = 28
--DECLARE @enemy2number INT   = 140000

SELECT
--*,
--damage * @troopnumber totaldamage,
--iif(damage * @troopnumber > m1health, 0, cast(m1health- damage * @troopnumber as int)+1)*3/ health monster1kill,
cast(@enemy1strength * @enemy1number * 3 / damage as int)+1 neededtokill,
@enemy1strength * @enemy1number / health kills1,
@enemy2strength * @enemy2number / health kills2,
(@enemy1strength * @enemy1number + @enemy2strength * @enemy2number)/ health maxkills
FROM
(SELECT
damage   = @troopstrength * (@troopbonusstrength + @troopbonusstrength2 + @aydaelevel+ 100)/100,
m1health = @enemy1strength * @enemy1number * 3 ,
m2health = @enemy2strength * @enemy2number * 3 ,
health   = (@troopbonushealth + @aydaelevel+ 100)/100*@troopstrength*3
)x``````

### Enter Parameters

Options:
-
Switch to meta site
Hold tight while we fetch your results
:records returned in :time ms:cached