I tried:

WHERE (ID = 4 AND @Show4 = 'y')

--OR

--AND

--(ID 4 AND @Show4 'y')

but OR or AND didn't do the trick 🙁

In SqlServer2000 I used the Database Diagram for documentation.

I divided the Database (120 tables) in four diagrams (each the size of a single page A4) on the 4 subjects...

Mark, I found out the way your code works, by recoding it without the CTE:

SELECT a.aName, c.* FROM

( -- Test Data base

select ID = 1 ,...

Mark, thank you :Wow:

I am impressed.

At this moment I don't understand the way it works.

But I'll try to analyze the parts, to find out what happens inside your code.

The...

Bob,

Thanks again :kiss:

I'll have look

Bob, you are very generous to help me so often, thanks.

I don't own the database, so I have to ask if I could add the UDF.

It is an efficient and...

@bob-2:

That magic approach is to much magic for me, sorry 🙂

About the performance, you have a point. I want to use this in a very heavy used View....

@arun-2 Sathianathan : Nice cheat. But I am sorry to tell you I can't use this because my example is a simplification of the real sql where it...

Quote: [font="Courier New"]"Just do Result time 1.6. Easy enough to include in the function."[/font]

I was hoping for new constants in the formula 😉

But I realize the formula doesn't need...

Please could you supply us a "km version" of this nice script.

In Europe, Australia, Asia, etc. we don't use miles or feet. 😉

Thank you for this interesting link.

But my situation is somehow another than the situation described by Karen.

I get an index seek (not a scan 🙂 )and a key-lookup (showing all...

I don't think using an INCLUDED column is a solution in this case.

I only use the index (on SelectID, IsOK and ConnectID) in the WHERE clause.

And all the columns (including...

OK, Zutendaal Belgium, Fleming. :smooooth:

And thanks for your tip on XML showplan, I'll use it in the future 😎

ALZDBA,

Thank you for your help.

I'm sorry that I can't show you the txt sqlplan (xml file renamed to .txt).

The fieldnames are in Dutch:alien: and not conforming the simplified table, I...

I tried your suggestion (in SSMS2005 on SqlServerDeveloper SP2) with an index on "SelectID, IsOK and ConnectID.

(temporary not in your suggested order, because ConnectID at this moment has only 1...