How to stop email alert , I put unsubscribe but it’s still coming
In Toad all you have to do is put :VariableName ( i.e. :DateInput) in your where clause. Example: Where SomeTable.DateOfService between :StartDt and :EndDt. when the user runs this query in Toad it will prompt them for two values. The better you make the variable names the more likely they will understand what to put in them. There is a prompting syntax you can use also that includes prompting text where you can show them the format of how you want them to enter something and any other helpful text as well. It is a little more complicated so I recomend starting with simple (just :variableName) and see if that works for you.