Question With IF..ELSE And Assignments In Transact SQL

I really need help with the following. I have a stored procedure that assigns values to declared variables and I need to make sure that I'm doing it right. It uses a lot of IF..ELSE statements which adds to the complexity, but here is a sample of code...


Code:

DECLARE @Code Int, @Weights Float

SELECT somestuff , @Code, @Weights

IF(something )
BEGIN
IF(something )
BEGIN
SELECT @Code = 2
SELECT @Weights = A*B
END
END

FROM a bunch of tables

WHERE a bunch of stuff



Now the stored procedure is way more complicated than above, I just want to make sure I can assigne values to the declared variables the way I have done in the example above. Currently I get an error on the FROM line of the stored procedure.

Any help on this would be greately appreciated 'cause I have several people telling different things in regards to assigning variables in Transact-SQL. Thanks in advance