pbaldy (2/26/2014)

---

Sure, the existing trigger is below. No cursor, and I can't imagine more than a single record being updated at a time. But being a novice I...

pbaldy (2/26/2014)

---

Forgive what may be a stupid question; being self-taught there are huge gaps in my knowledge. I have an existing trigger in a repair order table that updates...

Luis Cazares (2/26/2014)

---

And...

I am pretty sure you could get rid of the dynamic sql at the very least. Isn't this this same thing for Check 1?

/* check 1 */

IF @Check1 is null

insert...

I have a feeling too that you could make this entire thing into a few insert statements with no dynamic sql and no looping. It is so hard to read.

You need to look up sql injection. Your code is pretty much a text book case of vulnerable to sql injection.

As you are discovering you can't put a delimited list inside a variable and use IN to find all the values. You have a couple of choices here.

1) You could...

Your final query would end up something like this.

create table #Something

(

Area varchar(50)

)

insert #Something

select 'north,south,west'

select split.Item as Area

from #Something s

cross apply dbo.DelimitedSplit8K(s.Area, ',') split

drop table #Something

compufreak (2/26/2014)

---

Hi everyone

I have a problem, I am trying to split a row that currently has information like this:

area: north,south,west

however I want the area column to display the information like...

Your solution is a good one when all the data is aggregated though. 😛

Joey Morgan (2/25/2014)

---

As proof of the technique, I offer...

DECLARE @TestTable TABLE

(

id INT

,testValue NVARCHAR(10)

,someNumber INT

);

INSERT INTO @testTable

(id, testValue, someNumber)

VALUES

(1, 'First', 10);

INSERT INTO @testTable

(id, testValue, someNumber)

VALUES

(2, 'Second', 3);

INSERT INTO @testTable

(id, testValue,...

Joey Morgan (2/25/2014)

---

halifaxdal (2/25/2014)

---

Hello,

I have an existing query:

SELECT

i.Division,

DocStatus,

...

nadarajan_v (2/25/2014)

---

Hi,

I have an orders tables. From this table I have to retrieve all order Ids which are in the pending status. For these orders then I have to update...

kwoznica (2/25/2014)

---

Sean,

I think this will work. I just changed the sort order of Historical in the ranking function.

with NumberedSet as

(

SELECT ItemNo, Blocked, DoNotUse, Historical, rn = ROW_NUMBER() OVER...

You said the inner query returns the rows you want to update. That is basically the same thing I posted previously. Not sure what the point of the outer query...