The point of ddl and sample data is to make it easy for the people helping you. You didn't post ddl or sample data in a consumable format. Think create...

Hi and welcome to SSC!!! I will be happy to help. The first and most obvious thing is that you do not need a loop for this. I can't give...

That would certainly explain why the attempt is failing.

Something somewhere is trying to make a db connection with...

SCOPE_IDENTITY cannot be returning multiple values. It doesn't work like that. The return type is numeric(38,0).

http://msdn.microsoft.com/en-us/library/ms190315.aspx

As Lynn said, if you can provide some details we can provide some help.

ColdCoffee (5/16/2012)

---

Sean Lange (5/16/2012)

---

Thanks for the ddl and sample data. Based on your sample data what...

Thanks for the ddl and sample data. Based on your sample data what should the desired...

Jeff Moden (5/16/2012)

---

capn.hector (5/16/2012)

---

Sean Lange (5/16/2012)

---

OMG :w00t:

Jeff Moden posted a loop.

There is only darkness now, there is no sunshine. The mayans were correct.

Parden me, I must send out...

It was a 2 minute brief example of using exists to demonstrate the task at hand. I certainly was not expecting a code review. 😀

Your points are all certainly valid.

njdevils39 (5/16/2012)

---

Sean Lange (5/15/2012)

---

I assume by your silence that you did in fact get your issue resolved. It...

natha (5/16/2012)

---

I was wondering how will be the precedence of operation in following query:

UPDATE table1 t1

SET t1.col1 = (SELECT TOP 1 t0.col0 FROM table0 t0

WHERE t0.date_of_call < t1.date_of_call

AND (t0.dur_connection =...

Here is a simple example using exists to accomplish the type of behavior you are describing.

alter proc MyProc

(

@SomethingElse int

)

as begin

select top 5 * from sys.sysobjects as Something

if exists(select top 3...

Why can't you just calculate it? In this case there really isn't much need to calculate it. The formula you showed has only two possible values (0 or 100).

Jeff Moden (5/15/2012)

---

Actually, that's not true for these types of problems. ...

OMG :w00t:

Jeff Moden posted a loop.

There is only darkness now, there is no sunshine. The mayans were correct.

Parden me, I must send out an email blast to our...

What Jared...