• Something like below:

    Exec dbo. Sp_Number '1,2,3,4,5'

    Result Set
    1       USA   Chicago
    2       UK     England
    3       AUS   Melbourne
    4       CAN   Halifax
    5       UAE   Dubai

    1,2,3,4,5 are values for single parameter