Hi
I have a table and I want to INSERT a row for each day of the current month with the field Date containing just the number in. For example in Jan, I would have 31 rows with the field Date having the numbers 1 - 31. I am currently doing this by taking the current month and starting at 1st of the month, using DATEADD to add a day until the month changes and INSERTing a line for each day. It works fine but I was wondering if anyone could think of a simpler way of doing this.
Thanks
Chris
I have a table and I want to INSERT a row for each day of the current month with the field Date containing just the number in. For example in Jan, I would have 31 rows with the field Date having the numbers 1 - 31. I am currently doing this by taking the current month and starting at 1st of the month, using DATEADD to add a day until the month changes and INSERTing a line for each day. It works fine but I was wondering if anyone could think of a simpler way of doing this.
Thanks
Chris