Skip to Content
Former Member
Apr 01, 2008 at 09:44 PM

sql stored procedure parameters


Post Author: sharonmtowler

CA Forum: Data Connectivity and SQL

i created a stored procedure to use as my datasource.

i have 2 parameters that i would like to have the option of selecting ALL when the report is run. I would prefer have that in the stored procedure instead of the report selection. I am not clear on the syntax i should use. Currently i have

field= that only returns distinct value

can anyone help?