Dino Vliet wrote:
> I'm getting the same error without brackets.
Check the columns in table "lessons" matches the columns in your select.
> The EXECUTE statement was because I read something
> about executing dynamic content.
>
> I want to add 7 days to the date value of startdate
> and want to repeat it every week. Because there are 8
> weeks I choose to do that with the for loop going from
> 0 to 7.
Looking closer, I can see the problem. You're treating the column from
the select as a variable (which it isn't).
Try something like:
INSERT INTO lessons (col_name1, col_name2, ...)
SELECT dayofweek, startdate + (i*7), endate + (i*7), startime, ...
--
Richard Huxton
Archonet Ltd