Variable

[NoKeS]

I want to put the result of this code into a variable called @Factor: Like

Select @Factor = select Factor
from Moeda, Pedido
Where Moeda.Moeda='USD'
And Pedido.Abertura=Moeda.Data
And Pedido.Fecho is Not Null

How do I do??

 

[SeAL]

just like that:

Select @Factor = Factor from Moeda, Pedido Where Moeda.Moeda='USD' And Pedido.Abertura=Moeda.Data And Pedido.Fecho is Not Null

Hope this helps ...