I like to say "Just because you can do that in SSIS doesn't mean you should."  I don't know how many data flow's I've looked at where I end up...

I'm sure this could be done in one statement, but I wanted to break it down into steps, maybe it would be easier to read.  This should only return...

I removed everything for @FilterTable since it was not used or needed for the MERGE statement.

The query looks to be working correctly to me.  You show the results you are expecting to have '7 Los Am 920786777 CA 7'.  But this record would not be...

Having the one with the leading '.' not return anything just didn't seem right.  So here is what I came up with:SELECT COALESCE(SUBSTRING(Name, 1, NULLIF(NULLIF(CHARINDEX('.', Name) -1, 0),...

Something about keeping the running 'work day' count in the table just feels wrong.  I know, get over it because it works and is faster.  So I decided to test...

Here is what I set up as data:
CREATE TABLE dbo.source_table
(
    RecordId                        INT IDENTITY(1, 1),
    First_Name                        CHAR(50),
    Last_Name                        CHAR(50),
    Date_Of_Birth                    DATE,
    Age                                INT,
    Process_Date                    DATETIME,
    Yearly_Salary                    DECIMAL(13, 2)
)
;

INSERT INTO dbo.source_table

I haven't used this code in several years, I think it will get you what you want. I see others have already provided answers though.  It does loop through the...

All I can say is your original function was doing a count not a sum, and it had two additional checks in the where clause compared to what I was...

It's Friday so maybe I'm not thinking about this correctly.  But you are just trying to count the number of workdays between two dates, Correct?  Excluding the holidays you listed...

This code will get you close.  Maybe you or someone else can start with this to figure out how to be able to set it up to handle multiple tables. ...