Wednesday, June 19, 2013
Multiselect from pass a parameter in SQL
In simple we all aware that by using WHERE column IN (<multi values>) we can get the result from any query.
But when writing SP to retrieve results for reporting purpose I have doubt how to pass the the multi selected values as a parameter.
Because in SP parameter just behave as a string,
So, First thing is to separate the passing parameters in to indvidual values
And then set it to a table and return as a data result.
At last for the query call the above function by passing the parameter string.
Finally it will be very easy to get the result. :)