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. :)

No comments:

Post a Comment