>>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' >>>>
>>SELECT VoterID FROM tblCamp_CT WHERE [Assembly]='151' AND [Party]='R' AND [Propensity]='2' >>>>
>declare @SQL nvarchar(max) > >select @SQL = coalesce(@SQL + ' >UNION ALL ','') + 'SELECT VoterID from tblCamp_CT WHERE ' >+ Query FROM CompassQueries > >print @SQL > >execute (@SQL)Ok, I see what you're doing, excelt what's "Query"?