GP_NC (2/19/2012)

---

I do hope the last post gave a clearer picture. If someone can just tell me if using a trigger is the best way to handle this situation....

Can you post ddl including indexes for the tables?

Have you tried removing NOLOCK? You really should remove nolock regardless unless there is a good reason for it. In case you have never read it, here is a great...

Hi and welcome to SSC! It will help you get better answers if you can post ddl (create table scripts), sample data (insert statements) and desired results based on that...

SQL Guy 1 (2/17/2012)

---

I have simple query:

set quoted_identifier off

BEGIN tran

...

What exactly are you looking for? Are you trying to get the full ddl of all your tables including indexes, constraints, defaults, triggers, etc??? You should look into some sql...

GP_NC (2/16/2012)

---

This would be triggered by an insert into Table1. Then lookup the list to then insert multiple records back into Table1. As I am typing this I...

What does that mean? Did it not do what you expected? Did it do something else? Did you get an error message? Did your computer blowup?...

Oh I am beginning to now see the real issue. Your data is not normalized and you are trying to figure out to make it work with a poor data...

I think a bit more clarity of the scenario is required. What you have described is an infinite loop.

...paraphrased from your description...

I want to create an insert trigger on table1...

As Craig said, without tables and sample data this is pretty tough for us to help.

I tossed this quick example together to show you how you could use a tally...

To give you an example of how to use the splitter in that article with your sample data:

create table #MyTable

(

ID int,

SomeValue varchar(50)

)

insert #MyTable

select 12345, 'kais#2323232#def#323#'

select ID, Item from #MyTable

cross apply...

Lowell not sure what you are developing in but make sure you specify the DOCTYPE or border-collapse can have some strange results.

L' Eomot Inversé (2/15/2012)

---

Hugo Kornelis (2/15/2012)

---

Sean Lange (2/15/2012)

---

I still don't quite get the point to be honest. It is kind of like saying "you can insert data into this table...

Hugo Kornelis (2/15/2012)

---

Sean Lange (2/15/2012)

---

I still don't quite get the point to be honest. It is kind of like saying "you can insert data into this table but this trigger...