Posted by JayCallas on 12/07/05 01:10

Thanks for the reply Erland.

As you can see, I did the left-join so the user can pass null and get
everything or they can ask for specific symbols.

As to having different queries, what is the communities opinion about
having two queries in the same stored procedure and using an IF
statement to branch to one of them? Does that play havoc with the
execution plan since either query can be called? (I could create
another stored procedure to handle ALL securities but I already have
applications out there that use my existing one.)

[Back to original message]