Comments by lemzki (Top 1 by date)

Hi. It should be 366 columns in the results if i am going to put duration for the whole year. But i usually put between months, for example: Oct15-Nov20, November 1 result should be placed after Oct 31, not below Oct1. Months placed in horizontal position same as the dates. I tried to put isnull function after on aggregate max function after the pivot, but giving me error.