How to capture the dates in my Total

yes

no, just one column...insert all the dates found.

Never mind, I misunderstood your question.

let's say that @TotalPostingDays represented 21 records.  Some of the records had these dates:

1/1/2005
....
and so on

insert those into a table for me.  I need the actual records it found, not just the total here.

in this case, the dates, there are no records we're pulling from so that is what makes it hard for me.

Landy, thanks so much, not all I need to do is just check for holidays..much thanks!

Sorry, I left out the Holiday part.  

set nocount on
drop table #days
create table #days
      (MonthDay datetime,
      DayOfWeek int,
      Holiday bit)

declare @Start_date datetime,
      @End_date datetime,
      @date datetime
set @Start_date ='1/1/' + cast(datepart(yy,getdate()) as varchar(4))
set @End_date ='12/31/' + cast(datepart(yy,getdate()) as varchar(4))
set @date = dateadd(dd,-1,@Start_date)

--Load table with all of this year's dates and dayofweek
While @date < @End_date
  Begin
      SELECT @date = DATEADD(dd, 1,@date)

      INSERT INTO #days
      Values (@date, datepart(dw,@date), 0)

  end

--Set the holidays
UPDATE #days
SET Holiday = 1
From  Apex_ReportingServer.dbo.Holidays h
      INNER JOIN #days d on d.MonthDate = h.HolidayDate
WHERE      
      DatePart(yy,h.HolidayDate) = DatePart(yy,GetDate())


--Get this month's work days
SELECT MonthDay
FROM #days
WHERE Datepart(dw, MonthDay) not in (1,7)
      and DatePart(mm,MonthDay) = DatePart(mm,GetDate())
      and Holiday <> 1

I had already gone back and put the holiday stuff in before I saw the acceptance.  Thanks for the points.

So you actualy want to insert all working days into one column for given month, correct?
if yes tis should do the job

SET NOCOUNT ON
Declare @Holidays table (HolidayDate  datetime) -- this is temp table for holidays

Insert @Holidays values ('2006/1/1')                 -- just for test
Insert @Holidays values ('2006/1/2')

Declare @PostingDays table (PostingDay  datetime)  -- in this table we are going to insert dates



Declare @Today datetime -- is is your parameter date
select @Today= getdate()
Declare @CurrentDay datetime

Select @CurrentDay = cast( cast(year(@Today) as varchar(4)) +'/'+cast(month(@Today) as varchar(2)) +'/1'  as datetime)
WHILE month(@CurrentDay)=month(@Today)
      BEGIN
            IF NOT DATEPART(weekday, @CurrentDay) IN (1,7)
                  IF NOT EXISTS (SELECT * FROM @Holidays WHERE HolidayDate= @CurrentDay)
                        Insert into @PostingDays Values(@CurrentDay)
                SELECT @CurrentDay= DATEADD(Day,1,@CurrentDay)
      
      END
Select * FROM @PostingDays -- Check the results

Wow I haven't refresh my browser for long time, eh?