Microsoft SQL Sample Code

Execute Dynamic SQL

You may have a need to find dynamic values in your table - more than one value from the same field. For example, you may want to find any record in a table that has the State value of Iowa or Missouri. This sample script will show you how to accomplish this.

DECLARE @prmSql varchar(1000) DECLARE @prmSelect varchar(75) DECLARE @prmCriteria varchar(75) SET @prmSelect = 'MailingState, CustomerName' SET @prmCriteria = '''IA'',''MO''' SET @prmSql = 'SELECT ' + @prmSelect + ' FROM tblCustomers WHERE MailingState In (' + @prmCriteria + ')' EXEC (@prmSql)

If you need any help implementing this function or modifications made for your needs, please Click Here to get a free quote for your Microsoft SQL Development needs. 

Click Here to learn more about the WSI quoting process.