You beat me to it, Sean.

Are you editing your first post? If so, please don't. Just add new posts so others can follow what is happening.

Looking at your...

I would expect a "conditional join" to perform poorly.

My suggestion would be to join to the table twice

SELECT *

FROM T1

LEFT INNER JOIN T2 ...

You can test the rightmost two characters by using the RIGHT() function. In your example, try adding this to the WHERE clause.

AND RIGHT(dbo_vwCourseClass.ClassTitle,2) <> RIGHT(dbo_vwCourseClass_1.ClassTitle,2)

However, the solution above...

I finally took time to find this.... just for Jason.

http://www.musicbuzzer.com/randy-newman/naked-man-video.html

Fastest performance. (One pass... No Sort Required)

with cte (RowID,A,B,C,D,E) as

(

select 1,1,2,3,4,5 union all

select 2,3,1,5,3,2 union all

select 3,7,4,1,2,5

)

,cte2 as

(select *, case when A > B...

Just for fun

with cte (RowID,A,B,C,D,E) as

(select 1,1,2,3,4,5 union all

select 2,4,1,5,3,2 union all

select 3,7,4,1,2,2

)

,cte2 as

(select RowID,CA.* from cte

cross apply (values (cte.A),(cte.B),(cte.C),(cte.D),(cte.E)) CA (val)

)

...

You're welcome, Doug. This may be the first time I've ever been thanked for saying "NO".

Congratulations on making it happen with dynamic SQL. ...

The problem is that all statements are being checked against the table schema prior to the actual execution of the statements.

Simply put, the above...

There are two types of people in this world.

Those who can anticipate what's coming next.

Somebody remembered!

No problem, Mike. We all have moments like that.

It's working. You just can't see it with your print statement because you aren't trimming spaces from @X.

Try this

set @cmd = rtrim(@x) + ' '+ @y

print @cmd

P.S. ...

DBCC MyEyesMyEyesIveGoneBlind

However long it takes.

Your running rhino icon looks naked, Jason.

Would you consider changing your...