May 10, 2008 at 12:13 am
rbarryyoung that is a pretty sleek avatar 😀
May 10, 2008 at 10:23 am
Adam Haines (5/10/2008)
rbarryyoung that is a pretty sleek avatar 😀
Well, at least I got something right!
Seriously though, I was aware of those considerations Adam, that's why I said "Try *something like* this:" when usually I just say "Try this:". The OP's situation wrt to the matching conditions was somewhat ambiguous (as expanded by one of the OP's later replies) so I posted it with the intent that they would refine it to suit.
As for the scanning issue, that was already inherent in the OP's orginal, incomplete query and the OP wasn't asking for the performance to be fixed.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply