Are you trying it in SQL Server 2005? Or SQL Server 2000?

This is new for SQL Server 2005.




"Jeremiah Christensen "
<mssqldba-ezmlmshield-x49611587.[Email address protected]
06/30/2006 01:47 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
INTERSECT?






Okay this is my first attempt at using the INTERSECT operator and I keep
getting Incorrect syntax near the keyword 'INTERSECT'

Even something as simple as

select '5'

INTERSECT

select '5'

gives the error. Any tips on what's the proper usage? I've scoured the
web
and help files.





Jeremiah Christensen





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page