Sproc doesn't appear to do what I thought it should

[majordog]

Hey all,

below is a piece of code frominside one of my sprocs. When I run it in T-SQL-Debugger, none of the assigned variables receive any value from the below statement. Can somebody tell me me why?

SELECT samplemr = @samplemr, ambientmr = @ambientmr, avspan = @avspan, avzero = @avzero
FROM Emission_Results
WHERE [Id] = @EmissionID

 

[IDDQD]

Hi
it should be @variable = field not field = variable

HTH

 

[majordog]

That's what I just clued into - Thanks