This might be helpful: https://www.sqlservercentral.com/articles/ssis-as-an-execution-engine-for-multiple-sql-scripts

This is the output:

(No column name)SomeValue

13215 555 55 1 NULL

13215 555 55 2 NULL

11431 6 5 5555 hhh 1 NULL

11431 6 5 5555 hhh 2 NULL

114316 5 5555 hhh 3...

I am not sure the original request is still open, but assuming it is, I would definitely go with a CLR scalar function for such a request. Operations on...

Yes, everything works as it should if I set the Lookup to ignore failures. All the data gets loaded and I get my 14 matches. I will need...

Here is a quick update: I deleted everything in the package but the source and destination and then entire data set is transferred without a problem. Back in...

No errors occur on the data flow task. And the stored procedure from SMSS always returns 14000+ rows. And I have dumped the data into a table from...

I have tried deleting row 715 and that gets me a little further along, but not a lot further. That again makes me think that something in the column...

For lengthy strings, using CLR functions are the way to go. Not only are they much, much faster, they are very versatile. Attached is C# code for counting...

Hi All,

I thought I would give this a try, as it is something that I did a while ago and then left in a somewhat unfinished state. I recently...

I was asked to do the very same thing with XML a few weeks ago and this is a slightly simplified version of what I came up with:

declare @stringXML varchar(max),...

This is very nearly the same type of problem discussed in Phil Factor's SQL Speed Phreak challenge http://ask.sqlservercentral.com/questions/1227/the-subscription-list-sql-problem.html, which is also discussed nicely here http://www.simple-talk.com/sql/performance/writing-efficient-sql-set-based-speed-phreakery/. Besides being a good...

Try here: http://beyondrelational.com/modules/2/blogs/28/posts/10298/xquery-lab-17-how-to-update-the-value-of-an-element.aspx

If this is not exaclty what you need, there are lots of other examples of manipulating XML as well on this site.

Try the Parsename function. Not what is was made for, but works quite well for what you need and is much faster that CharIndex and Len.

Duration for CHARINDEX =...

This might work, but the values need to be unique in each of the 3 columns. The SQL script creates and joins three tables in a CTE. Table one...

Try running the query as a UNION ALL instead and see if your query plan is any better. While it shouldn't make a difference when you upgrade to SQL...