Personally, this feels like a job for powershell, not SQL Server.

Just because SQL Server CAN do it, doesn't mean it SHOULD do it.

SQL Server is a database engine and you...

As a thought - are you sure it is the conversion that is causing the slowness?

What I mean is what if you take out the INSERT INTO statement and just...

I am not certain on the default trace, but I think you could set up an XE session to capture that.

How is the tool running the drop script?  I am...

Everything you listed plus support and more features (SSRS, SSAS, SSIS, etc) and scalability.

Commercial tools, in general, should perform better than the free tools when properly configured.  An improperly configured...

SSDT, if I remember right, allows for a lot of different things you can do with it including, but not limited to, SSRS, SSIS, SSAS, etc.

Knowing what type of project...

To me it looks like whatever process you have for populating the parameter (@DBName) is busted.

Now as to why it isn't working, you would need to look into what populates...

I agree with Grant and Piet here - there are no shortcuts with it.

One thing that can help though and I strongly recommend is to adopt a coding standard AND...

My approach would be to look at where the problem is and determine what you want to do to fix it.

What you indicated is that the string MUST end in...

If I am understanding your request properly, something like this should work, right:

WITH [cte]
AS
(
SELECT
[Mobile]
, [WorkTelephone]
, [HomeTelephone]
, [FirstName]
, [LastName]
, [PolicyNumber]
, COUNT(1) OVER (PARTITION BY
 [Mobile]
 , [FirstName]
 ,...

oh sorry.  I misunderstood.  I think that will be a bit more challenging as you are essentially going to need to rip apart the XML.  I think this may fall...

I don't see why you can't do this.  You already have it started, just need to expand on it to capture each and every element in the XML.  Something along...

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

It might not hurt to reach out to Vormetric as well.  It is a paid tool, so might as well get their support.

From my experience, once corruption happens, unless I...

I think your problem is with your WHEN statements.  Let us look at the first one:

WHEN CAST(CONCAT(CREATE_DATE, ' ', CREATE_TIME) AS DATETIME) BETWEEN
dateadd(hh, 15, dateadd(dd, -1, convert(datetime,...

I agree... there isn't much to go on.

Having an execution plan and DDL would definitely help us help you.  Without that, it is impossible to know what would help.  Adding...

An alternate solution that doesn't rely on the DelimitedSplit8K:

WITH [SampleData2] ([PERSONNUM], [ORGPATHTXT])
AS
(
SELECT
231089
, './Company/20-00001/120---30-00006/40-00506/50-99506/60-29145/97455001/0097455001/Fire-Grill'
UNION ALL
SELECT
121564
, './Company/20-00001/120---30-00006/40-00073/50-00075/60-26275/68990001/0068990001/Location3/Burger-Cook'
UNION ALL
SELECT
999998
, './Company/20-00001/120---30-00006/40-00073/50-00075/60-26275/77990993/0077990993/Location6/Food-Worker'
)
 , [sampledata3] ([PERSONNUM], [ORGPATHTXT], [NoLocation], [ContainsLocation])
AS
(
SELECT
[SampleData2].[PERSONNUM]
, [SampleData2].[ORGPATHTXT]
, REPLACE( [SampleData2].[ORGPATHTXT]
 ,...