Thanls for the resource. This is what I came up based on it.

Select s.DateOfRange, s.SignedCount,r.ResignationsCount,n.NetSignedCount,

(

SELECT SUM(n2.NetSignedCount)

...

I went with the seperate temp tables and did a inner join to link them all together in a single record set. But I have one last issue:

Select t1.DateOfRange, t1.SignedCount...

If I have to use multiple temp tables, how would I join them together in order to get one flat recordset back?

;with

SCount as

(SELECT d.DateValue AS DateofRange , Count(Distinct c.ConsultantID) AS SignedCount

FROM #DateList d LEFT JOIN Consultant c ON d.DateValue=c.NACDate

WHERE d.DateValue between @StartDate and @ENdDate

...

I am not sure that gives me what I want. The records set needs to be 'flat'. When I use the UNION ALL it just returns everything in two columns...

I think I need to UNion them because the final reslut set should be some like

DateOfRange, SignedCount(1st script), ResigniationCount (2nd script)

This has been working base on the #DateList table (thanks) but what how would I combined the following two recordsets into a single record set:

SELECT d.DateValue AS DateofRange , Count(Distinct...

Cool that worked perfectly.

I find this interesting:

When I run this based on my date table:

SELECT d.DateValue AS DateofRange , Count(c.NacDate) AS SignedCount

FROM #DateList d LEFT JOIN Consultant c ON d.DateValue=c.NACDate

WHERE d.DateValue between @StartDate...

I was thinking along the lines of creating a temp table to hold the dates generated by the date range and then join to it as I need it. But...

THis worked great. Thanks a lot.

Yes, I looked but they really didn't seem to fit what I was after. I understand the CASE statements but that not how the proc works.

I would really appreciate a example. THe Shearch critertia is broke done into 3 section:

Criteria 1: Amount Filters

Criteria 2: Line Filters

Criteria 3: Status Filters

Each of these filters are used to...

Any ideas on this issue?

I ran into a small issue. In one case I am returning 2 rows where it shoould only be a single: Code:

Select c.ConsultantID,

...