If the procedure actions can be specified in a (table returning) function, you may find that a cross/outer apply will do the trick. In this instance, the function is called...

Here is the script modified (I think) to work with a table returning function. This time (unless I am doing something dumb) it does seem to show the Extended Property...

Thanks for your reply.

To provide an example, I built this script:

IF OBJECT_ID('[DBO].[TstFn]') IS NOT NULL

DROP FUNCTION [DBO].[TstFn]

GO

CREATE FUNCTION DBO.TstFn ()

RETURNS INT

AS

BEGIN

RETURN(1)

END;

GO

SELECT VALUE FROM...

Thanks Jeremy, nice example! (Would I lose anything by using CTE's just to keep from getting so confused?)

I'm just pondering what a "ofdm" might be?

Don't feel sheepish -- I'll bet there are many other lurkers (like me) that learn a good deal when others ask our basic questions!

Christian: re example 2:

Instead of:

...

,case when (long-complex-conditional-expression)

then valuefield else 0 end as [$]

,case when not (long-complex-conditional-expression)

...

Interesting! Where can I find SQLCE Workshops I-III?

Thanks, you are right.

(I'm glad I added the CYA "but since I miss even the things that are documented clearly..." above.) (CYA s/b CMA.)

Damn -- I thought I had just learned a quicker way to check query performance. Just can't trust anything any more.

Thanks!

Andras -- you are right again.

The real surprise, which at first made me worry I was doing something dumb, was that the version with only the two fields of interest...

Thanks Matt! And that also avoids the confusion created by the sub-query (although it makes it T-SQL specific). Yet a third approach to analyze and time.

PW, thanks.

This is one of those cases where I am unwilling to rely on the fact that I "know" that (today) there should be no records that are duplicates...

Since MS Access munges SQL code so bad, I've found it useful to run the Access SQL through the Instant SQL Formatter at:

http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm

It is not without some flaws*,...

Always a good start is Strunk and White:

http://www.amazon.com/Elements-Style-Fourth-William-Strunk/dp/020530902X

(Sorry, I could not find the ISBN number.)