Need quick SQL Server Advice

2002-07-18 Thread Brian Scandale
I have a query that works well with postgreSQL I just uploaded the code to a SQL Server installation and this query is failing with the Error: --- Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near 'LIMIT'. SQL = SELECT * FROM SPCData, Device WHERE

Re: Need quick SQL Server Advice

2002-07-18 Thread Douglas Brown
17, 2002 11:29 PM Subject: Need quick SQL Server Advice I have a query that works well with postgreSQL I just uploaded the code to a SQL Server installation and this query is failing with the Error: --- Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near

Re: Need quick SQL Server Advice

2002-07-18 Thread Paul Hastings
SELECT TOP 8 * FROM SPCData, Device WHERE SPCData.SPCDitem_ID = 1 AND SPCData.SPC_Device_ID = Device.Device_ID ORDER BY SPCData_ID DESC --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.375 / Virus Database: 210 - Release

Re: Need quick SQL Server Advice

2002-07-18 Thread Brian Scandale
Paul, Doug Thanks! At midnight things get blurry At 11:48 PM 7/17/02, you wrote: SELECT TOP 8 * FROM SPCData, Device WHERE SPCData.SPCDitem_ID = 1 AND SPCData.SPC_Device_ID = Device.Device_ID ORDER BY SPCData_ID DESC --- Outgoing mail is certified Virus Free. Checked by AVG