Hi,

Thank you for the information on datename, which worked out, still i need the following info.

I would like to arrive the sum of set values from one column where dates...

I feel that calendar table will help, but i have already date columns and values in the table, hence do i need to go for calendar table or is there...