• I'm not a big fan of reading XML query plans but a quick search through the XML revealed several IMPLICIT_CONVERSIONS, which depending on the number of records this occurs on, can adversely affect performance. Please make sure you are assigning the proper datatypes in your CASE statements and WHERE clause items.

    Ex: If Customer Account in stored as an integer, don't declare it and pass it as a varchar(20)

    (example only)

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience