access sql to sql server - 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 2005 Forums

Transact-SQL (2005)

access sql to sql server

Author

Topic

sushiboy
Starting Member

12 Posts

Posted - 2007-06-01 : 10:07:20

this is my sql in access below..how would it look in sql server ?
SELECT universe2.Ticker, universe2.Analyst
FROM universe2
WHERE (((universe2.exchange)<>"industry") AND ((InStr(1,[ticker],"mgtmeet"))=0))
GROUP BY universe2.Ticker, universe2.Analyst
ORDER BY universe2.Ticker;

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-01 : 10:50:10

Try this

SELECT universe2.Ticker, universe2.Analyst
FROM universe2
WHERE (((universe2.exchange)<>"industry") AND ((charindex('mgtmeet',[ticker]))=0))
GROUP BY universe2.Ticker, universe2.Analyst
ORDER BY universe2.Ticker

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources