Microsoft SQL Server 2000 does not allow the use of
variables in some parts of your SQL Statement. Two examples of this non use
are selecting a variable top number of rows and defining a variable where
clause. However, there are several ways to overcome these obstacles. In this
article I will define an SQL stored procedure called DynamicSQL. This
procedure allows the caller to provide multiple parameters.