How to enable index seex with this case

  • Yes start-up filters are a favourite of mine too. They come in handy for all sorts of things (conditiional joins, for example). I've found myself using them a little less since really embracing 2008, but they're still a fine tool to have available.

    Dynamic SQL works well for this sort of problem too, and the plans are much easier for the optimizer. Smaller too.

    Paul

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply