Try something new like with table value parameter more simple and more powerfull

or cast Xml type in an in line function

http://msdn.microsoft.com/en-us/library/bb675163(v=vs.110).aspx

http://www.brentozar.com/archive/2014/02/using-sql-servers-table-valued-parameters/

http://www.codeproject.com/Articles/39161/C-and-Table-Value-Parameters

For BI reports (SSRS) use : http://geekswithblogs.net/GruffCode/archive/2012/06/21/using-table-valued-parameters-with-sql-server-reporting-services.aspx