I've got the following that works:
Code:
--Retreive Input info------------------------------------------------
DECLARE @InStart datetime
DECLARE @InStops datetime
SET @InStart = '09/09/2005 16:20:00'
SET @InStops = '09/12/2005 16:20:00'
--Declares
DECLARE @MonTable table (Payer_Name varchar(35) NOT NULL, Monday int)
DECLARE @TueTable table (Payer_Name varchar(35) NOT NULL, Tuesday int)
DECLARE @WedTable table (Payer_Name varchar(35) NOT NULL, Wednesday int)
DECLARE @ThrTable table (Payer_Name varchar(35) NOT NULL, Thursday int)
DECLARE @FriTable table (Payer_Name varchar(35) NOT NULL, Friday int)
DECLARE @dayStart datetime
DECLARE @dayStops datetime
--Monday
----Get Dates
exec spMT_Get_HTC_InputDates @InStart, 0, 'Start', @dayStart output
exec spMT_Get_HTC_InputDates @InStops, 0, 'Stops', @dayStops output
----Get Data
INSERT INTO @MonTable (Payer_Name, Monday)
SELECT PAYER_ABBR_NAME as Payer_Name, SUM(ACCEPTED) as Monday
FROM SUBMITTER_PAYER_COUNT
WHERE CREATED_DATE >= @dayStart AND CREATED_DATE <= @dayStops
GROUP BY PAYER_ABBR_NAME

--Tuesday
exec spMT_Get_HTC_InputDates @InStart, 1, 'Start', @dayStart output
exec spMT_Get_HTC_InputDates @InStops, 3, 'Stops', @dayStops output

INSERT INTO @TueTable (Payer_Name, Tuesday)
SELECT PAYER_ABBR_NAME as Payer_Name, SUM(ACCEPTED) as Tuesday
FROM SUBMITTER_PAYER_COUNT
WHERE CREATED_DATE >= @dayStart AND CREATED_DATE <= @dayStops
GROUP BY PAYER_ABBR_NAME

--Wednesday
exec spMT_Get_HTC_InputDates @InStart, 2, 'Start', @dayStart output
exec spMT_Get_HTC_InputDates @InStops, 4, 'Stops', @dayStops output

INSERT INTO @WedTable (Payer_Name, Wednesday)
SELECT PAYER_ABBR_NAME as Payer_Name, SUM(ACCEPTED) as Wednesday
FROM SUBMITTER_PAYER_COUNT
WHERE CREATED_DATE >= @dayStart AND CREATED_DATE <= @dayStops
GROUP BY PAYER_ABBR_NAME

--Thursday
exec spMT_Get_HTC_InputDates @InStart, 3, 'Start', @dayStart output
exec spMT_Get_HTC_InputDates @InStops, 5, 'Stops', @dayStops output

INSERT INTO @ThrTable (Payer_Name, Thursday)
SELECT PAYER_ABBR_NAME as Payer_Name, SUM(ACCEPTED) as Thursday
FROM SUBMITTER_PAYER_COUNT
WHERE CREATED_DATE >= @dayStart AND CREATED_DATE <= @dayStops
GROUP BY PAYER_ABBR_NAME

--Friday
exec spMT_Get_HTC_InputDates @InStart, 4, 'Start', @dayStart output
exec spMT_Get_HTC_InputDates @InStops, 6, 'Stops', @dayStops output

INSERT INTO @FriTable (Payer_Name, Friday)
SELECT PAYER_ABBR_NAME as Payer_Name, SUM(ACCEPTED) as Friday
FROM SUBMITTER_PAYER_COUNT
WHERE CREATED_DATE >= @dayStart AND CREATED_DATE <= @dayStops
GROUP BY PAYER_ABBR_NAME

--Join data
SELECT Mon.Payer_Name, Monday, Tuesday, Wednesday, Thursday, Friday
FROM @MonTable Mon
INNER JOIN @TueTable Tue ON Tue.Payer_Name = Mon.Payer_Name
INNER JOIN @WedTable Wed ON Wed.Payer_Name = Mon.Payer_Name
INNER JOIN @ThrTable Thr ON Thr.Payer_Name = Mon.Payer_Name
INNER JOIN @FriTable Fri ON Fri.Payer_Name = Mon.Payer_Name
ORDER BY Mon.Payer_Name
I tried to simplify it doing this, but the SUM function gets confused and totals too much data:
Code:
--Retreive Input info------------------------------------------------
--Input values
DECLARE @InStart datetime
DECLARE @InStops datetime
SET @InStart = '09/09/2005 16:20:00'
SET @InStops = '09/12/2005 16:20:00'
--Declares
DECLARE @day1Start datetime
DECLARE @day1Stops datetime
DECLARE @day2Start datetime
DECLARE @day2Stops datetime
DECLARE @day3Start datetime
DECLARE @day3Stops datetime
DECLARE @day4Start datetime
DECLARE @day4Stops datetime
DECLARE @day5Start datetime
DECLARE @day5Stops datetime
--Monday
----Get Dates
exec spMT_Get_HTC_InputDates @InStart, 0, 'Start', @day1Start output
exec spMT_Get_HTC_InputDates @InStart, 1, 'Start', @day2Start output
exec spMT_Get_HTC_InputDates @InStart, 2, 'Start', @day3Start output
exec spMT_Get_HTC_InputDates @InStart, 3, 'Start', @day4Start output
exec spMT_Get_HTC_InputDates @InStart, 4, 'Start', @day5Start output

exec spMT_Get_HTC_InputDates @InStops, 0, 'Stops', @day1Stops output
exec spMT_Get_HTC_InputDates @InStops, 3, 'Stops', @day2Stops output
exec spMT_Get_HTC_InputDates @InStops, 4, 'Stops', @day3Stops output
exec spMT_Get_HTC_InputDates @InStops, 5, 'Stops', @day4Stops output
exec spMT_Get_HTC_InputDates @InStops, 6, 'Stops', @day5Stops output
-----Join Data
SELECT Mon.PAYER_ABBR_NAME as Payer_Name,
SUM(Mon.ACCEPTED) as Monday,
SUM(Tue.ACCEPTED) as Tuesday,
SUM(Wed.ACCEPTED) as Wednesday,
SUM(Thu.ACCEPTED) as Thurssday,
SUM(Fri.ACCEPTED) as Friday
FROM SUBMITTER_PAYER_COUNT as Mon
INNER JOIN SUBMITTER_PAYER_COUNT Tue ON Tue.PAYER_ABBR_NAME = Mon.PAYER_ABBR_NAME
INNER JOIN SUBMITTER_PAYER_COUNT Wed ON Wed.PAYER_ABBR_NAME = Mon.PAYER_ABBR_NAME
INNER JOIN SUBMITTER_PAYER_COUNT Thu ON Thu.PAYER_ABBR_NAME = Mon.PAYER_ABBR_NAME
INNER JOIN SUBMITTER_PAYER_COUNT Fri ON Fri.PAYER_ABBR_NAME = Mon.PAYER_ABBR_NAME
WHERE Mon.CREATED_DATE >= @day1Start AND Mon.CREATED_DATE <= @day1Stops
AND   Tue.CREATED_DATE >= @day2Start AND Tue.CREATED_DATE <= @day2Stops
AND   Wed.CREATED_DATE >= @day3Start AND Wed.CREATED_DATE <= @day3Stops
AND   Thu.CREATED_DATE >= @day4Start AND Thu.CREATED_DATE <= @day4Stops
AND   Fri.CREATED_DATE >= @day5Start AND Fri.CREATED_DATE <= @day5Stops
GROUP BY Mon.PAYER_ABBR_NAME