Ed Wagner (6/17/2016)

---

And I think that's fine. If you...

Luis Cazares (6/16/2016)

---

Brandie Tarvin (6/16/2016)

---

Everyone say goodbye to Texas. I do believe it's going to disappear soon. :w00t:

On a serious note, I'm really hoping no one gets hurt when this...

I would recommend using one or the other. Using multiple splitters is awfully confusing.

yuvipoy (6/15/2016)

---

What about this ?

Create Table test12 (i int, j int)

insert into test12

Select 1,5

Create procedure test

(@tablename varchar(10),

@filedval int,

@where int)

as

Begin

declare @String varchar(200)

set @String = 'Update '+ @tablename +' Set j...

I have to ask....why are you using two different splitters?

SplitString

&

DelimitedSplit8K

ScottPletcher (6/14/2016)

---

Sean Lange (6/14/2016)

---

ScottPletcher (6/14/2016)

---

My advanced knowledge, "tricky" q is:

In autocommit mode, when can an UPDATE statement partially complete, some UPDATEs made, some not, where SQL does not roll it...

ScottPletcher (6/14/2016)

---

My advanced knowledge, "tricky" q is:

In autocommit mode, when can an UPDATE statement partially complete, some UPDATEs made, some not, where SQL does not roll it back?

Edit:...

Steve Jones - SSC Editor (6/14/2016)

---

Sean Lange (6/14/2016)

---

TomThomson (6/14/2016)

---

Interesting question.

Even more interesting answer statistics. The documentation is very clear and up-front about two limitations: (i) resource govenor doesn't work...

ChrisM@Work (6/14/2016)

---

Sean Lange (6/14/2016)

---

Luis Cazares (6/14/2016)

---

Sometimes I just want to post RTFA(rticle).

People are given answers with an article that explains the solution, but won't bother reading and keep posting...

Luis Cazares (6/14/2016)

---

Sometimes I just want to post RTFA(rticle).

People are given answers with an article that explains the solution, but won't bother reading and keep posting saying they don't...

llouw1 (6/14/2016)

---

hi

I am pressed for time...as we all are LOL...

all I need to do is read through the table and for every new record I need to re-set...

llouw1 (6/14/2016)

---

Thank you so much.

no - in your example - where you have a variable @String - I would have a table and not just one variable e.g.

1,4:yes 6:yes 7:yes...

TomThomson (6/14/2016)

---

Interesting question.

Even more interesting answer statistics. The documentation is very clear and up-front about two limitations: (i) resource govenor doesn't work across instances and(ii) resource govenor doesn't concern...

Brandie Tarvin (6/14/2016)

---

Ed Wagner (6/14/2016)

---

BrainDonor (6/14/2016)

---

Brandie Tarvin (6/14/2016)

---

I am seriously considering removing my LinkedIn profile all of a sudden. I did not join to be marketed to. According to this...

patrickmcginnis59 10839 (6/10/2016)

---

Sean Lange (6/10/2016)

---

[quote-0Well on the same line of trying to determine if this is a good question or not, maybe not everybody does queries with aggregation either. The...