I tried with global temp table still error, actually it has no issue with ssrs, it throw an error in management studio as well only when i select all the list from the parameter. it was exact same error. is there number of limitation of parameter list in any proc? not sure what could be the issue.
thanks
Sagar