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, 1 month 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]
 ,...

Oh I completely agree.  you should clone to your local disk, not a network share.  And a good way to prove to them that is the way to go -...

I'm not that familiar with RStudio, but I know git and their idea of versioning by folder is something unneeded in git.

In git, the way I would handle it is...

I actually thought the same thing as homebrew01 - when the query completes, the table should go away.  The exception is with temporary tables, which would go away when the...

I did find one way to do this, but it relies on the query still being in the plan cache and is not a very "automated" approach and has potential...

• This reply was modified 4 years, 1 month ago by Mr. Brian Gale. Reason: Updated for more accurate lookups

I was actually just experimenting with this and I am mistaken on how you would find it.

Turns out the plan cache doesn't map this up either... I am going to...