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 -...

You can't use a variable like that. You should look at the link in my signature for splitting a string.

--EDIT--

Hint -- your query would end up something like this.

select *...

To prove my point I altered my proc with yours above. Then to test the nested transactions is quite simple.

begin transaction

exec proc1

commit transaction

It doesn't work.

You really should read the article I posted above. Nested transactions are lie, myth, whatever you want to call it....