Posted by Hugo Kornelis on 09/27/74 11:53

On 20 Jul 2006 04:45:02 -0700, Bit Byter wrote:

(snip)
>A typical query then may look like this:
>
>Select all 'toys' from 'Walmart' where average_sales(100) > 100000 and
>avaerage_cost(100,10) <= 1 and item_date between "01-Jan-00" and
>"01-Jan-06"
>
>
>I would like to know what the underlying SQL statement will look like,
>so that I can use this knowlege to build a generic parser that creates
>SQL statements from the "English like" text, using the syntax I
>described above.

Hi Bit,

That depends on what the tables look like. If you post the table
structure (as CREATE TABLE statements, including all constraints,
indexes and properties), some rows of sample data (as INSERT statements)
and expected output, I'm sure that you'll get several suggestions how to
write a query.

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: Reduce Table Size without deleting data
• Prev in forum: Re: Scripting table with rows values
• Thread view: Re: SQL Generator

[Reply to this message]