• Yep,

    If sp_executesql would accept the table variable as a parameter, you would be out the tunnel.

    Unfortunately it only accepts parameters that are Unicode or can be explicitly converted to ntext. @Table variables can't..........

    Bit of a pain but - looks like you will have to find an alternative Dallen

    Have fun

    Steve

    We need men who can dream of things that never were.