sqlharmony (8/14/2012)

---

Assuming you are filtering on the column that you are partitioning against, partition elimination will ignore any partitions that do not contain the value that you are looking for....

So I set up a quick test using this setup:

USE test

GO

CREATE TABLE testStringReplace (string VARCHAR(250))

INSERT INTO testStringReplace

SELECT TOP 500000 c1.name + '%' + c1.name + '%'

FROM sys.columns c1

CROSS JOIN sys.columns...

dwain.c (8/14/2012)

---

Playing around with PATINDEX, which is the closest thing you'll find to REGEX (except the CLR REGEX functions of course), I come up with something like this:

;WITH SampleData (string)...

TRUNCATE TABLE mytable

INSERT INTO mytable (firstcolumn, secondcolumn)

SELECT firstcolumn, secondcolumn

FROM OPENQUERY (mylinkedserver, 'SELECT firstcolumn, secondcolumn FROM linkedtable')

roryp 96873 (8/13/2012)

---

But based on the desired output he provided it looked like he wanted the % signs removed as well. Or did I misread that?

Edit: Nevermind, I...

@rory: Sorry I was not clear that sometext could be anything; i.e. %sometext%, %hogwash%, '%palinka%'... So your proposed solution will not work.

@g: No need to use replace, I think your...

GSquared (8/13/2012)

---

I could be wrong, but I'm pretty sure Replace() won't take regex or other patterns. I'm pretty sure it only deals with strings or string-type variables with pre-defined...

You do it the same way you output 1, you just...

-on 8/1/2012 files being imported by backend job

-on 8/2/2012-8/3/2012 user make tons of change to the data via front end

-on 8/4/2012 updated files being imported

if we reverse back to 8/1/2012...

USE [RECLACSR-DB]

GO

/****** Object: StoredProcedure [dbo].[InfoPrComplement] Script Date: 08/09/2012 15:00:58 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:<Author,,Name>

-- Create date: <Create Date,,>

-- Description:<Description,,>

-- =============================================

ALTER PROCEDURE [dbo].[InfoPrComplement]

-- Add the...

Lynn Pettis (8/8/2012)

---

SQLKnowItAll (8/8/2012)

---

Lynn Pettis (8/8/2012)

---

I can tell you it took some playing when I was doing it. Problem is it was so long ago it is hard to...

roryp 96873 (8/8/2012)

---

Maybe my files I am using are encoded differently than yours or maybe I am missing something here, but any time I have had to load a whole...

Lynn Pettis (8/8/2012)

---

I can tell you it took some playing when I was doing it. Problem is it was so long ago it is hard to remember what we...

Nope, but BULK INSERT seems to be working now... Just can't get the row terminator right.

Ok, but what I...