Timeline for Best way to work around NOT IN NULL issue?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 18, 2012 at 15:07 | vote | accept | user606723 | ||
| May 3, 2012 at 18:27 | comment | added | JNK | In SQL Server it gets treated as a derived table, so it only gets calculated once. The only time you get a row-by-row execution is if the outer table value is used in the inner table, normally. | |
| May 3, 2012 at 18:26 | comment | added | user606723 |
Is there any performance repercussion to doing so many sub-queries? Or will the server be smart enough to realize it doesn't need to be evaluated for each row of yourtable
|
|
| May 3, 2012 at 18:15 | history | answered | Mikael Eriksson | CC BY-SA 3.0 |