that's ok, guys,

i'm solving the problem with a SP.

thanks,

levogiro.

sergiy,

there's no table storing the dates. i want to pass 2 dates to a SQL command and calculate them in this command.

benedito.

hello again,

what i need is to list all days between two given dates in a single SQL command.

thanks,

benedito.

ok,

sounds like a good idea. but is there another choice if i don't really have a calender table to work with ?

benedito.