November 17, 2011 at 8:51 am
Hi,
I have a procedure with two input parameters @bank and another one is @productid,for these two parametrs i want to write a code
in the procedure that option to seelct multi selction;for this i will put in the report properties change to single select to multi select
but in the procedure we need to handle...
i have a code for single selction and for ALL in my procedure
for single selection
IF(@productid IS NOT NULL) AND (@productid <> 0)
BEGIN
DELETE FROM #Rpt22036WorkTable
WHERE ISNULL(productid,0) <> @productid
END
and for ALL means here 0 for this i have..
IF (@productid IS NULL)
SELECT @productid = 0
ELSE
SELECT @productid = @productid
and i need a code here for @bank and @productid how to multi select the list in the drop down.... can anyone help me..
November 17, 2011 at 9:07 am
Duplicate post. Please post responses here: http://www.sqlservercentral.com/Forums/Topic1207598-392-1.aspx
Please don't cross-post. It fragments the discussion.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
November 17, 2011 at 9:28 am
Then whom i have to post the question,thats a t-sql code right?
November 17, 2011 at 10:10 am
Yes, it's a T-SQL question, but you posted in both the T-SQL (SS2K5) and the T-SQL (SS2K8) forums. I assume you know whether your server is SQL 2005 or SQL 2008, so you should be able to figure out which forum is more appropriate.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply