Lucasprss (6/18/2012)

---

Sorry I did mean a left outer join, I am trying to update these fields with in a view. I really dont see what the issue is, I am...

OK that is what I thought but wanted to make sure I understood.

Lynn Pettis (6/18/2012)

---

Lowell (6/18/2012)

---

left inner join? no such animal exists in SQL, so that's probably not what you meant. it's either a left outer outer or an inner join...

Sean Lange (6/18/2012)

---

komal145 (6/18/2012)

---

select '10704' as entry_id , '2012-05-18 14:17:20.710' as Start_time ,'2012-05-18 14:18:13.957' as End_time ,'test3' as USername

Union all

select '10704' as entry_id , '2012-05-18 14:24:45.057' as Start_time ,'2012-05-18 14:25:14.780'...

komal145 (6/18/2012)

---

select '10704' as entry_id , '2012-05-18 14:17:20.710' as Start_time ,'2012-05-18 14:18:13.957' as End_time ,'test3' as USername

Union all

select '10704' as entry_id , '2012-05-18 14:24:45.057' as Start_time ,'2012-05-18 14:25:14.780' as End_time...

Lynn Pettis (6/18/2012)

---

komal145 (6/18/2012)

---

select '10704' as entry_id , '2012-05-18 14:17:20.710' as Start_time ,'2012-05-18 14:18:13.957' as End_time ,'test3' as USername

Union all

select '10704' as entry_id , '2012-05-18 14:24:45.057' as Start_time ,'2012-05-18 14:25:14.780'...

It is not really help to provide any actual details but it sounds like your insert/update is trying to do this on two tables at the same time. You can't...

Well if you rollback inside your other proc it will rollback all the "nested" transactions. Then your trancount will be off and it will fail. There are probably some other...

OK now I am even more confused. I just realized that you tried to demonstrate output in your first post. There were two rows originally but now you say only...

That didn't exactly make it very clear. Can you show what the expected output should be based on your sample data?

Given the code snippet I am guessing you are using some sort of looping splitter. I am already thinking you can vastly improve performance by reading the article in my...

There is nowhere near enough information posted here to have any chance of helping. There are variable referenced and a lot of details that we don't know about. This is...

Yeap clear as mud. So the query you said works doesn't work with the ddl and sample data provided. The ddl is full of typos.

I don't quite understand why you...

Pretty sparse on details here. What does the VB code look like? What does the sql you are using look like?

You will get lot more help if you can...

This is kind of like taking your car to the mechanic and telling them it doesn't run well. Imagine your response at the car repair shop with this conversation.

You -...