I loaded your code into Management Studio and the syntax checks out fine in 2005. I suspect the ADP designer just can't handle it, but it should...

My rating should be "Threadhead" instead of Ten Centuries, but I'm making it a point to spend more time answering questions than "chatting" here in The Thread. 😉

I wasn't going to say it, Jeff. 🙂

If all the function is used for is to find a single date (like the first...

Also keep in mind that normalisation is a logical concept, not a physical one.

Multiple indexes and summary tables are everyday examples of redundancy that don't seem to...

Is this....?

Nevermind.

.... and a novel thought...

Why not just have the nested proc return those two values as output parameters itself, rather than as a two-column, one-row result set? ...

jc 🙂

I'm so happy someone else has seen that show. I loved the original...

This came up in another thread. You can find a couple of competing solutions here.

Basically, you can run an IF Exists with your query to see if there...

Hey... what's an "UPDATE" ?? Can I use it to increment a date?

It was new in 2005, Matt. 🙂

Cross Apply and Outer Apply also work very well with table-valued functions.

If the function is an inline (single query)...

It really is.... 😉

ESPECIALLY for the classic... "I need all the data from the row that has max([col])."

Try it, you'll like it.

Sounds like a good idea to me, Bruce.

Also, I used Cross Apply because I believe it's going to produce a more efficient execution plan for you. Please let me know how it performs with your...

You shouldn't need all three. The first two are both summary queries with the same search criteria, and could be combined. You could also combine subqueries...

I shook him off from my neck a long time ago, O Ancient Mariner. 😎