• Probably the best option if you need to preserve that variable number of output columns is to bung the lot into a stored procedure and use @NAMEID as a parameter.

    http://msdn.microsoft.com/en-us/library/ms345415(v=sql.120).aspx

    you'll then be able to execute it with something like

    EXEC sprocFindAddress @NAMEID = 12345

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------