Sorry, hope this is helpful. Thanks! 🙂

CREATE TABLE #myTable
(
ID int,
ITEM char(1),
PCT int,
BEGDT datetime,
ENDDT datetime
);

INSERT INTO #myTable (ID, ITEM, PCT,...

Thanks for the reply Thom,

Distinct won't work because I need to have the MIN of BEGDT and MAX of ENDDT for two contiguous date ranges. For example, on...

I have the same problem. Created a few reports a couple weeks ago. Now when I open the project, file, solution, etc. the reports always open in xml view. How...

Has anyone figured this out yet?

If so, please give specific steps on how to do this.

Thanks!