You don't explicitly have to declare a @params variable in this particular example, but it's probably a good idea. Your code could be modified slightly

...

Thanks for the response Geoff. To your initial question about the nulls, part of the reason for wanting to make the returns null was that if say, stock A trades...