you can check to see if the start time > end time and subtract 1 from the date of the end time, but that only assumes that it will be...

Do you have a split string function already?  If not you can find one here http://www.sqlservercentral.com/scripts/T-SQL/100014/
Then simple call to it

select *

If the xml is the same, then you could use a dynamic pivot

Use TempDB

drop table if exists test

create table test (id...

I changed the join to numbers to cast the values as dates and it returns the 5th line I believe you are looking for.  Also, I changed the data to...

why do you want to concatenate these 3 columns in the where clause anyway?  Are you joining against a table where it concatenated together?  Otherwise,  why not just put in...

How is the data stored?  Based on what you asked, you want to concatenate DOB to Fullname and then search by it.  Something like:

where FullName in  ('01/01/2000 Sarah...

There was some bad data in there, that e didn't account for.  I added the criteria below

   ;WITH CTE AS (
        select pcode,pkey, RowEffectiveDate, rowenddate,...

I don't see an attachment

Try this.

btw, my table has over 200,000 records and the query returns in 5 seconds without the PCode = parameter

INSERT INTO #dimP (pcode, pkey,...

DECLARE @SQLString nvarchar(500);
SET @SQLString =
'declare @String nvarchar(500) = ''SELECT BusinessEntityID, NationalIDNumber, JobTitle, LoginID
FROM '' + @DbName + ''.HumanResources.Employee '' EXECUTE sp_executesql...

Did you look at the plan to see what it was doing?  How much is alot of data?

This will convert it to YYYYMMDD which would be easier to find if more than one year is in the folder.

select convert(varchar(10), getdate() - datepart(DW, getdate())...

Depends on which day is the first day of  the week.  I threw this together to get 2 Saturdays ago, but I'm sure there's a better way.  Just ran out...

Drew is right,  Put that in an Execute SQL task and assign it to a variable in the package, then in the Expression Builder, you can reference the variable.  Set...