I agree with jcelko here 100%.

If this table structure is not pre-defined for you, I would definitely look at doing it in at least 1st normal form.  You will also...

Never mind... sounds like the issue is actually not in the DATEADD part, but possibly in the JOIN.

• This reply was modified 5 years, 10 months ago by Mr. Brian Gale.

for the jobs that run SSIS packages, my approach is to script out the job steps table joined to the jobs table.  Something like:

USE [msdb]
GO
SELECT 
name, step_name,...

I've not done something like this (we don't use SSAS or MDX at our shop), but it sounds like a good use case for CASE:

https://docs.microsoft.com/en-us/sql/mdx/case-statement-mdx?view=sql-server-ver15

My thought, based on past experiences, is that you are having memory pressure.

We had an intermittent SSIS package.  Most of the time it completed in under an hour (40-ish minutes),...

Also Brian, can we think about breaking this string down into various columns such as A[bcd] will be broken down to A,[,b,c,d,].... and then we cross apply A with...

When the SSIS package is running on the NEW server, and getting stuck at that 1-5 hour step (and further and pegging CPU and such), how much RAM is free?

My...

I think this was answered in another post already, no?

String Split won't work here as you have no delimiter on your strings.

Something to add to the TALLY solutions proposed above is that they miss the cases where there is...

• This reply was modified 5 years, 10 months ago by Mr. Brian Gale.

What application consumes this data?  The application that is consuming this data is the application I would use to parse it.

If it is to be consumed in Excel, then I'd...

My recommendation is to do this application side still, but if database side is the solution you need, this query should do it:

DECLARE @tmp TABLE
(
[Letters] VARCHAR(25)
);
INSERT INTO...

Solution in this case, going back to the UNPIVOT example, basically the same thing, just put more values into the IN statement.  In your case replace the FOR [header] IN...

Could you provide some DDL for this so we can consume the data and replicate it?

A quick guess here is that you are going to be looking at unpivot or...

I think this really depends.

My first step would be to determine what output format is required by the end user.  If they require it to be a comma separated list...

First - I have not seen this issue before, but we are a fully SQL Server shop where I work without any Oracle boxes.

When you say it works correctly in...