Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to avoid subs() on left side of equal
Message
 
 
To
16/11/2009 11:44:46
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01434947
Message ID:
01434974
Views:
42
I know and you're right - too much work to exclude items. Perhaps our first suggestion is going to be just fine.

>>Actually, the LEFT JOIN solution is wrong - I just realised. The LEFT JOIN only works if we need to exclude items, but what if there is nothing to exclude to begin with?
>
>
>Seems like you're excluding - you changed not like to like
>
>But whatever - you're selecting twice from dbo.Meetings
>
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform