create proc [dbo].[multivalueinputproc] (@country nvarchar(1024)=null)
as
set nocount on
declare @countrytable table(Code nvarchar(75))

if IsNull(@country, '')=''
	Begin
		set @country='ALL'
	End
--print @country
Else 
	While Len(@country) > 0
		Begin
			If patindex('%,%', @country)> 0
				Begin
					insert into @countrytable
					values (rtrim(substring(@country, 1, patindex('%,%', @country)-1)))
					set @country = ltrim(substring(@country, patindex('%,%', @country)+1, 1024))
				End
			Else
				Begin
					insert into @countrytable
					values (ltrim(rtrim(@country)))
					break
				End
		End
--print @country
if (select @country) = 'ALL'
	Begin
		select * from customers
	End
Else
	Begin
		select * from customers
		where country in (select * from @countrytable)
		Order by country
	End

    Public Shared Function ReturnXML(ByVal MultiValueList As Object, ByVal Root As String, ByVal Node As String, ByVal Element As String) As String
        '**************************************************************************
        '   Returns an XML string by using the specified values.
        '   Parameters:
        '   MultiValueList - a multi value list from SSRS
        '   Root, Node, Element - String to use in building the XML string
        '**************************************************************************
        Dim ReturnString = ""
        Dim sParamItem As Object
        ReturnString = " "
        For Each sParamItem In MultiValueList
            ReturnString &= " "
        Next
        ReturnString &= " "
        Return (ReturnString)
    End Function