Hello and welcome to ssc.

Your second INNER JOIN condition references the table alias of the first. This should work, assuming suitable values in your data:

SELECT

u1.Name AS first,

u2.Name AS...

Sorted - it's running those results unaggregated into the table variable which is costing so much. I'd guess you might get a 20-fold lift by aggregating each...

Lowell (1/25/2013)

---

also, my rule of thumb is that any @TableVariable with more than a few hundred rows should be a temp table instead, to allow the system to automatically do...

Sql Student-446896 (1/25/2013)

---

Hi,

I have a beginning Year and a End year and i have to compute/create a string based on the given years.

Example:

Input: BegYr = 2013 and EndYr = 2015

Output:...

Lynn Pettis (1/24/2013)

---

Good. Now, if you would please post the code you are are using, not just refer me to my old...

SQLRNNR (1/24/2013)

---

ChrisM@home (1/24/2013)

---

SQLRNNR (1/24/2013)

---

john.arnott (1/24/2013)

---

Am waiting with bated breath to see if "Saint" Lynn lives up to his kind and understanding reputation. Someone stumbled on an old QOD...

How about EXCEPT?

SELECT 'TableA', *

FROM (

SELECT * FROM TableA

EXCEPT

SELECT * FROM TableB

) a

UNION ALL

SELECT 'TableB', *

FROM (

SELECT * FROM TableB

EXCEPT

SELECT * FROM TableA

) a

SQLRNNR (1/24/2013)

---

john.arnott (1/24/2013)

---

Am waiting with bated breath to see if "Saint" Lynn lives up to his kind and understanding reputation. Someone stumbled on an old QOD thread about...

I haven't posted it yet! :w00t:

Abu Dina (1/23/2013)

---

Lol Chris you scare me.... And embarrass me at the same time.

Simple solution....

This is another addition to the various phonetic algorithm implementations I have. Always hoping for better...

Hack your query down to the minimum which still exhibits the strange behaviour you are observing. If you haven't figured it out by the end of the exercise, code up...

Try searching for dwainc's article CROSS APPLY VALUES, it's the simplest solution for this. If you can't find it, post up ddl and dml for your 50-row table. The link...

Abu Dina (1/23/2013)

---

Hi Chris hope you're well!

Thanks for the thread. I shall go and have a thorough read in a mo.

I'm really grateful you brought my attention to iTVF Last...

It looks like you are using a query designer for this, and worryingly, it looks like the result has been achieved by accident rather than by design. Here's the full...

How are you doing, Abu Dina?

As luck would have it, one or two of us have been experimenting with exactly this requirement here on this thread, which will continue to...