cross apply - cool trick in sql server

[@fairywhore]

You can also use cross apply to go off and get data from somewhere else while youre inside your query and using something from your query.
Select tt.* from thisTable tt
Cross apply(
Select ot.* from myOtherTable ot
Where ot.col1 = '4'
) myResult
Where tt.col2 = myResult.col2
Just random untested code but can be useful

[@VeaceslavBARBARII]

Left ear: OK
Right ear: -
You'd better record mono rather than half stereo.

[@bobhoover1066]

who cares?

[@cristianramos7343]

@@bobhoover1066 i do. it bothers

[@chillbro2275]

This is really cool! I wish it worked for window functions though. But this is definitely appreciated and useful.

[@ConanNYC]

great trick!

[@bobhoover1066]

Great video!

[@superfreiheit1]

Cant see. You need to zoom in

[@maatos]

You ended up with more code in the end

[@this-is-bioman]

Yeah, really cool. Does not explain anything.