I heard there was a recently deciphered passage from the Dead Sea Scrolls that discussed such a parameter, but the fragment containing the ARID (alternate...

Memphis is about 14 hours by car from Orlando....

ROAD TRIP!!!

I guess I need to have some BBQ for lunch *today*.

Perhaps a BBQ tour is in order.

Lynn, I didn't know it was possible to have a BBQ sandwich that WASN'T pulled pork.

Okay.... now the debate shifts to which BBQ place in Memphis.

I'm not sure it is necessary because the col2 values come from Table A in the first place.

However, upon reflection, it is quite possible that other...

My reasoning was that he first produces a distinct setof values, then gets a simple count of rows from Table A which have values in that set. However...

Without data to test, this is a shot in the dark, but....

SELECT COUNT(DISTINCT docid) -- docid is primary key of Table A

FROM [Table A] a

JOIN [Table B] b...

I'm not sure, Lutz. I'm reading his code more thoroughly right now.

He only wants counts of values that come from Table B.

I'm getting to come again this year. How early do volunteers have to arrive?

Answer: $%@#*'ing it up.

Is $%@#*'ing a...

The very thought makes me quiver.

We could start a rhyme of...

It was a dark and stormy night....

declare @DoNothing int

begin try

select 1/0 as result

end try

begin catch

set @DoNothing = 1

end catch