This is what i have for converting to a Julian date, also included is converting a Julian date back to a regular date.

DECLARE @input_date DATETIME;

"The leadership of PASS regularly changes, and we see that again this year with three new board members starting this January. I'd like to welcome John Martin, Diego Nogare, and Chris...

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...