CELKO (12/22/2014)

---

Please follow basic Netiquette and post the DDL we need to answer this. Follow industry and ANSI/ISO standards in your data. You should follow ISO-11179 rules for naming data...

I believe this could be done more efficiently using the XQuery Substring method but I could not quickly figure out how.

In the meantime, here's a solution...

-- (1) create...

I have a partial solution, that will get you in the right direction. I created some DDL for you. This solution is based on the technique described in this article:...

No prob. Glad to help. 😎

Back up your RDL before doing this...

In Visual Studio right-click on the report and select "View Code". In the code you will see a footer section. I'm pretty sure...

Eugene Elutin (12/11/2014)

---

Alan.B (12/10/2014)

---

I'm curious (general question to everyone)...

Wouldn't this be faster?

-- the function

CREATE FUNCTION dbo.DIGITSONLYAB(@pstring varchar(8000))

RETURNS TABLE WITH SCHEMABINDING AS

RETURN SELECT ISALLDIGITS = CASE PATINDEX('%[^0-9]%',@pstring) WHEN 0...

I'm curious (general question to everyone)...

Wouldn't this be faster?

-- the function

CREATE FUNCTION dbo.DIGITSONLYAB(@pstring varchar(8000))

RETURNS TABLE WITH SCHEMABINDING AS

RETURN SELECT ISALLDIGITS = CASE PATINDEX('%[^0-9]%',@pstring) WHEN 0 THEN 1 ELSE...

Using this PatReplace8K function:

CREATE FUNCTION dbo.PatReplace8K

(

@String VARCHAR(8000),

@Pattern VARCHAR(50),

@Replace VARCHAR(1)

)

/*

Created by Alan Burstein Nov(ish)/2014

With help by Eirikur Eiriksson 😉

*/

RETURNS TABLE WITH SCHEMABINDING

AS

RETURN

WITH E1(N) ...

Sean Lange (12/9/2014)

---

Alan what you posted is almost exactly what I had envisioned. I refrained from posting simply because this seems so much like homework. Let's hope the OP reads...

I put something a little more simple together.

USE tempdb

GO

-- Sample Data

IF OBJECT_ID('tempdb..items') IS NOT NULL DROP TABLE items;

CREATE TABLE items (Price int);

GO

INSERT items

SELECT ABS(CHECKSUM(newid()))%10+6--5 to 15

FROM (VALUES (NULL),(NULL),(NULL),(NULL)) t(c);

GO

--...

Removed... (Did not see that this was an Integration Services thread). What I put together would be wrong. :doze:

Eirikur Eiriksson (12/4/2014)

---

Quick suggestion (pseudo code)

😎

DECLARE @ParamTable varchar(100) = N''; -- include...

Argh, I put together a longer reply...

-- Sample data matching what you have

DECLARE @tblCCH TABLE

(PKID int primary key,

OrderID int not null,

CCXML xml not null

);

INSERT @tblCCH

SELECT 1,31677,'<?xml version="1.0"?> <CC> <Type>4</Type> <Name><![CDATA[Lisa M. xxxxx]]></Name> <Amt>51.86</Amt>...

You can create a SQL agent job then create a step that executes the package. SSIS Packages are one of the options under Steps for "Type"