Retrieve data from a created column

Question

Good evening, I have a table with 4 fields and through them I do some calculations and create a new field to show these same results... The problem is that then I want to get those results and I don’t know how I can rescue them.

declare @mesAtual as int = (6)

        select  mes, 
                valor, 
                periodicidade , 
                cast(valor / periodicidade as decimal(18,2)) as ValorMes,
                case when @mesAtual > mes then @mesAtual - mes
                when @mesAtual < mes then (periodicidade - (mes - @mesAtual)) + 1
                when @mesAtual = mes then 0 end as Diferenca

        from tblPrevista

Answer 1

One way to solve the problem would be to take this query of yours and play inside a subquery, and then select these fields that you want "on the outside". Would look like this:

declare @mesAtual as int = (6)

SELECT  *,
        ValorMes * Diferenca as Final
FROM  
(SELECT mes, 
        valor,
        periodicidade,
        cast(valor/periodicidade as decimal(18,2)) as ValorMes,
        CASE 
        WHEN @mesAtual > mes then @mesAtual - mes
        WHEN @mesAtual < mes then (periodicidade - (mes - @mesAtual)) + 1
        WHEN @mesAtual = mes then 0 end as Diferenca
 FROM tblPrevista) as tblPrevistaCalculos