Re: [SQL] SQL Subqueries on each result row

2009-09-24 Thread Mark J Camilleri
On Wed, Sep 23, 2009 at 6:33 PM, Jim wrote: > On Sep 23, 5:43 am, AnthonyV wrote: > > Hello, > > > > I have a table like : > > > >date|value > > --- > > 2009-09-19 | 1 > > 2009-09-20 | 2 > > 2009-09-21 | 6 > > 2009-09-22 | 9 > > 200

[SQL] Error on dynamic code.

2005-07-14 Thread Mark J Camilleri
TEMENTS-ASSIGNMENT )   Which is basically identical (except for the WHERE clause) to the query returned in the my error message!!   Can anyone help please?   Regs, Mark J Camilleri