I'm guessing you have some data that is throwing this off.

Do the subselect's work fine by themselves?

I'd think you'd be able to CASE the SUM and not need the...

where string like column?

Isn't it WHERE MyCol like '%searchstring%'

I hate these types of searches. I think it's a lazy developer. It might take you more time to build a few...

Crazy as a Jedi?

Google might do that. We actually have some development resources coming available in a couple weeks and this is one of the priorities to fix the search so it works...

There shouldn't be a lot of duplication. There are some older ones from before we had a unique check on the column.

Who's duplicate?

I'm sure he knows how to cut and paste, but might not use that term. What if he's primarily a *nix guy? Might not be used to the term. I'm...

That's great. 😀

Fortunately I've worked at and been in a reactor so I'm not more nervous than I would otherwise be.

sometimes I'm afraid people are writing something like that and we're helping them!

I just hope if it's anything involving people's lives or money that there's a code review.

And after lunch, I'm lost again in this thread.

Yeah, defending against poor SQL :w00t:

Grant, beware, I saw her throwing people all over the dojo at Puget Sound Aikikai

don't worry anyway, she won't hit you. Just a throw through the air, and that doesn't hurt.

The landing, on the other hand, ......

Hit you?!?!?! She shoots arrows. Not sure the other side of the room...

Lynn, I think that's very true, and it's hard to teach someone how to develop that gut instinct. I think it's something that takes time, and a lot of experience.

I'm picturing more a bolo style sling that whirls above the cubes, the top of Jeff's hair just visible!

I'd guess it would be something like an sp_addrole to the dbo role. Or maybe sp_addalias for the user to dbo?

My v6.5 syntax is rusty, but it was close to...