Each has its place, neither is actually better than the other for most applications. You get into the niche areas, that no longer becomes the true. There may...

Alright, seeing you laugh makes it all worthwhile! :w00t:

Sergiy (2/9/2009)

---

Actually, the question was not for you.

🙂

You may realize that if you look at...

Actually, Sergiy, I have no idea. Since Adi posted what appears to be a working solution, I have tried yours nor worked...

The problem we are having is trying to decode your logic. It would help if you could clarify the logic more like the following:

(This is not SQL code, but...

Looking back through the posts, it appears tha Adi has already provided a working solution, so I won't look into this further at this time.

Judy (2/9/2009)

---

arun.sas (2/9/2009)

---

Tray this

simple

Create table #t(rating int,bookid int)

insert into #t

select 97, 201

union all

select 96,100

union all

select 95,300

union all

select 50,100

union all

select 10,201

union all

select 30,300

select a.rating,b.bookid from #t a, #t b

where...

Olga B (2/9/2009)

---

Great article. The best thing about the suggested approach is that if the poster takes the time to define the problem and consider the test data and the...

Eat (2/9/2009)

---

We are running into a similar issue.

When attempting to login through a Windows Group, I receive the "Cannot open user default database. Login failed." message. Default...

It would help if you upload the actual execution plan.

At least I don't have to rely on SQL Server for those, my wife is a Massage Therapist.

You may close the issue, but you failed to answer the question, why you needed procedure A to know if it was called by procedure B or called independently of...

There are also changes to any indexes that need to be logged in case of a rollback. In addition, when you are doing the delete, what else is going...

It would help to have the actual execution plan and the code. It may also help to have the DDL for the tables including indexes. Just from your...

Okay, Venkat, you have had several replies to your question as well as I asked of you. How about some feedback?