Adding variable value based on counting number in Sql server query

Question

User1623409651 posted

Hi,

I want to add the variable values based on counting number in sql server query

Suppose I have variable value = 40 and count number = 3 then result will be

40+ 40+40 = 120

Basically counting number is dynamic

suggest the way

Regards,

Answer 1

User-893317190 posted

Hi Rameezwaheed,

Not sure about your requirement.

Seems you want to get value*number, then declare a variable value and a variable number.

 declare @value int;
 declare @number int;
 set @value=40;
 set @number =3;
 select @value*@number

If this is not your case , please show your data in  table and your desired result.

Maybe you need case keyword in sqlquery.

https://www.w3schools.com/sql/sql_case.asp

Best regards,

Ackerly Xu

Answer 2

User-1716253493 posted

SELECT @var * count(*) ...