Optimization of a Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Optimization of a Query

Author

Topic

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2001-06-28 : 11:34:11

IS there a better way to write this query?

select id from table1
where id not in
(select id
from table1 as a, table2 as b
where b.name = 'xyz' + cast(id as nvarchar))

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources