hi, i have a stored procedure and has 3 parameters, like projectname,project leader, dept. i am able to pass single value using sp,but multiple values using a query. when i use select all in the drop down box of the parameter list, it takes value in csv format? isnt it? so if i am using the sp it is not accepting multiple value , i mean if i select the select all check box, i am unable to generate the report, but query works fine with the select all option. so can anyone tell me the way in which a sp can accept the multiple values in each parameter??
Check on these links: They may help you. http://weblogs.asp.net/jmoon/archiv....asp.net/jmoon/archive/2005/04/01/396649.aspx http://sqlserveruniverse.com/forums/thread/480.aspx
[quote user="preethi"] Check on these links: They may help you. http://weblogs.asp.net/jmoon/archiv....asp.net/jmoon/archive/2005/04/01/396649.aspx http://sqlserveruniverse.com/forums/thread/480.aspx [/quote] The first link throws with the error Bad RequestBad Request
[quote user="Madhivanan"] The first link throws with the error Bad RequestBad Request [/quote] That is a nice way of pointing my Double paste error [] http://weblogs.asp.net/jmoon/archive/2005/04/01/396649.aspx is the first link
<P mce_keep="true">[quote user="preethi"] <P>[quote user="Madhivanan"] <P>The first link throws with the error <STRONG>Bad RequestBad Request</STRONG></P><P>[/quote]</P><P mce_keep="true"> </P><P>That is a nice way of pointing my Double paste error <IMG alt="Big Smile" src="http://sql-server-performance.com/Community/emoticons/emotion-2.gif"></P><P><A href="http://weblogs.asp.net/jmoon/archive/2005/04/01/396649.aspx">http://weblogs.asp.net/jmoon/archive/2005/04/01/396649.aspx</A> is the first link </P><P mce_keep="true"> </P><P>[/quote]</P><P>Thanks []</P>