Smart Notification Stored Procedure

the question is do you want the Admin that i updating/processing the infoset to be prompter or do you want the user who is viewing a Notification to be able to enter a value to filter the notification? If the former, its very simple. If the later, its very complicated and its easier to not to use data side filtering if your data set isnt hundreds of rows. If it is it will be a bit complicated. Let me know if this is the preferred method (server side filtering initiated by end user of Notification) and ill try to shed some light on it.

I just would like to be prompted with a list of values to choose from that will be sent to the stored procedure variable used inside the where clause. ..

Still need to know where you want to be prompted, when the infoset is updated or in the dashboard where the notification will be published? If in the infoset then your SQL should look something like this: Select * from title where token = [token] If the other, its much more complicated.