Here is what your query would look like using the DelimitedSplit8K.

create table #MyTable

(

ID int,

Price int,

List varchar(20)

)

insert #MyTable

select 3, 89, '67,68,69' union all

select 4, 120, '45,46'

select t.ID, t.Price, x.Item

from #MyTable t

cross...

I agree with Luis that you need the splitter. I would however recommend going one step further and normalizing this data. You should not be storing delimited values like that...

prtk.raval (6/3/2013)

---

Ok...I think I am very new to this forum..So if somthing has been done wrong, than it must be unintensionally.

I will now create a one topic and stick...

Glad that works for now. I have to agree with the sentiment of the others that parsing this into appropriate columns would be best. It is however incredibly difficult to...

Ok so here is the deal. You have now created a number of totally disconnected threads all on the same subject. Myself and others have attempted to assist you but...

Lowell (6/3/2013)

---

Sean Lange (6/3/2013)

---

You lost me a bit in here. There is no MERGE statement in what I posted. There is no delete. It is simply an insert statement with...

prtk.raval (6/3/2013)

---

Hi,

So my issue is..

I am copying the whole table with OPENQUERY from linked server(oracle) to sql server2008R2 in any temp. table A.

than I am copying just P.K. to another...

It is rather difficult to know exactly what you...

prtk.raval (6/3/2013)

---

Hi,

Ho I can run 2-3 sql statments in one go, which are based on above's query value.

for an example.

first statment copy the data from linked server into new table...

You shouldn't need to do any explicit conversion for that. It...

monilps (6/3/2013)

---

While passing parameters in exec statement can we use CAST or not.

I am getting error while using CAST to pass the parameters.

Example:

EXEC dbo.abc CAST(0 as bit), null

NOTE: I need...

albertosantiagop (6/3/2013)

---

hello every one I need help...

I have two Instance. Instace A and Instance B. I need to restore a backup that are store in instace A

to instance B....

GilaMonster (6/3/2013)

---

Ed Wagner (6/3/2013)

---

I've actually used this tactic in conducting interviews. I felt that some people were trying to bluff their way through the technical portion of the interview...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

If you are just trying to set a value for all inserted rows why not make it the default? Then you don't have to worry about a trigger at all?...