• Hi,

    I'm a little confused... :ermm:

    your first and your second post both describe a rather large update statement.

    However, your third post is regarding an insert statement and in the last post you're talking about a completely different, but more simple update statement.

    I would have expected data definition and sample data for the first case rather than two new issues leaving the first one unanswered at the same time...



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]