At 1/10/2003 10:38 AM, you wrote:

>I'd like to create a calendar table inserting all of the day of the
>current year.
>Is there any way to select days or count of it from current month
>(and select months or count of it from current year)?
>Or any else ideas?

Write a stored proc to do it:

create procedure Populate_Calendar(Start_Date date, End_Date date) as
begin
while (Start_Date <= End_Date) do begin
insert into Calendar(cal_date)
values (:Start_Date);
Start_date = Start_Date + 1;
end
end


hth,

Bob M..