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

jcarranza's solution will also work; my preference is still to create a role and use that role to assign permissions.  What happens to that user/login when they quit  and a...

My guess is you have system restore turned on for that drive.

Setting a limit for VSS likely won't make a difference, but reducing the limit for system restore or turning...

Can you provide some sample data where it is not ordered correctly?  All of my testing on my system indicates that it should  be ordered correctly EXCEPT if you go...

Offhand, I am not sure why they can see all of the databases if they only have permissions on the one.  A quick check online, it sounds like this isn't...

EDIT - I misunderstood the request.  My response was wrong.  Deleted.

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