Previous Next

• 05-14-2008, 5:25 PM

  sshd.root Joined on 05-14-2008, 9:13 PM Posts 1

  Multi query SELECT Reply Contact The content of my sql file: SELECT count(*) as QUANTITY1 FROM SYSTEM, SECURITY, APPLICATION WHERE ( EventType = 1 ) and TimeGenerated >= TO_LOCALTIME( SUB( SYSTEM_TIMESTAMP(), TIMESTAMP('4', 'd') ) ) SELECT count(*) as QUANTITY2 FROM SYSTEM, SECURITY, APPLICATION WHERE ( EventType = 2 ) and TimeGenerated >= TO_LOCALTIME( SUB( SYSTEM_TIMESTAMP(), TIMESTAMP('4', 'd') ) )   When I trying run command: LogParser.exe -i:EVT file:sql\test.sql -o:DATAGRID  I  have got error: Error: Syntax Error: extra token(s) after query: 'SELECT'   Can i use two SELECT function in same sql file ???   P.S. I am sory about my English

  Tags: helplogparser

• 05-15-2008, 1:20 AM

  In reply to

  qbernard Joined on 03-26-2003, 2:12 AM Malaysia Posts 2,260	Re: Multi query SELECT Reply Contact multiple select statement is very buggy, some details in this thread. http://forums.iis.net/p/1148395/1865990.aspx Cheers, Bernard Cheah