>My client has a table called CompassQueries which stores WHERE clauses:
>
>

>ID            CampaignId   Query
>----------------------------------------------------------------------------------------------------------------------------
>425         140               [Assembly]='151' AND [Party]='R' AND [Propensity]='4'
>429         140               [Assembly]='151' AND [Party]='R' AND [Propensity]='3'
>430         140               [Assembly]='151' AND [Party]='R' AND [Propensity]='2'
>

>
>So I now need to run a query that returns a DS of voters who match these queryies:
>
>It would be the same as running this:
>

>SELECT VoterID FROM tblCamp_CT WHERE  [Assembly]='151' AND [Party]='R' AND [Propensity]='2'
>

>
>except the WHERE clauses come from the CompassQueries table for all rows that match the campaign.
>
>How do I do this?


You will need dynamic SQL here, e.g.

declare @SQL nvarchar(max)

select @SQL = coalesce(@SQL + '
UNION ALL ','') + 'SELECT VoterID from tblCamp_CT WHERE ' 
+ Query FROM CompassQueries

print @SQL

execute (@SQL)