Common stored procedure to update all tables

See more:

C#

SQL

I have a program to validate addresses, right now I am using this console app by calling it with two procedures one for input address and another for output address.

The first procedure returns the list of addresses to be validated and the second one updates validated addresses back to the table.

From console (c#) app I am calling the first procedure, validating each address and calling the second proc by passing values of the validated address

Recently the webservice exposed a new method for validating addresses in bulk. I am looking for a solution to have only one get proc and one set proc to update any table with addresses so the same console can be used by other processes.

Below is the XML I have thought of to pass to the proc. How can I build a dynamic sql to update the table ?

<AddressValidator>
    <ValidationResults>
        <ExtensionData />
        <Results>
            <ValidationResult>
                <ExtensionData />
                <ReturnCode>-1</ReturnCode>
                <ErrorCode>491</ErrorCode>
                <ErrorMessage>Failed DPV because of invalid primary</ErrorMessage>
                <CASSDate>0</CASSDate>
                <ValidatedAddress>
                    <ExtensionData />
                    <InputAIID />
                    <ID>501</ID>
                    <AddressLine1 />
                    <AddressLine2 />
                    <City />
                    <State />
                    <ZipCode />
                    <County />
                    <MailRoomServer />
                    <FirstName />
                    <LastName />
                    <Business />
                </ValidatedAddress>
            </ValidationResult>
        </Results>
    </ValidationResults>
    <Mappings>
        <Map_Type>Input</Map_Type>
        <Data_Table>Addresstable</Data_Table>
        <AddressLine1>MAIL_ADDR1</AddressLine1>
        <AddressLine2>MAIL_ADDR2</AddressLine2>
        <City>MAIL_CITY</City>
        <State>MAIL_STATE</State>
        <ZipCode>MAIL_ZIP</ZipCode>
        <isBadAddress>BadAddressYN</isBadAddress>
        <ErrorCode>SatoriErrCode</ErrorCode>
        <ID>ID</ID>
    </Mappings>
    <Mappings>
        <Map_Type>Output</Map_Type>
        <Data_Table>Addresstable</Data_Table>
        <AddressLine1>VAL_MAIL_ADDR1</AddressLine1>
        <AddressLine2>VAL_MAIL_ADDR2</AddressLine2>
        <City>VAL_MAIL_CITY</City>
        <State>VAL_MAIL_STATE</State>
        <ZipCode>VAL_MAIL_ZIP</ZipCode>
        <isBadAddress>BadAddressYN</isBadAddress>
        <ErrorCode>ErrCode</ErrorCode>
        <ID>ID</ID>
    </Mappings>
</AddressValidator>