adrian.facio (4/24/2012)

---

Hi, what do you think about this one?

-- A tally table is needed.

CREATE TABLE Numbers (Number INT)

INSERT INTO numbers

SELECT TOP 1000 row_number() OVER (

ORDER BY column_id

)

FROM sys.columns;

-- Number...

+1

Maybe you should create a total of 3 procs. One is the main "driver" proc which has your conditional check(s).

create procA

if (somecondition)

exec procB

else

...

Thanks for being honest about it being homework. It helps make the response in such a way as to guide you instead of feeding you the answer. From your response...

As another thought you should read this article about using the nolock hint.

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Basically, you should not use it, ever. Dirty reads can be acceptable in some situations but isolation...

Just ignore him. He will go bother somebody at some other site once he realizes nobody will respond anymore. He is clearly...

GSquared (4/23/2012)

---

I would feel sorry for the passersby.

If they watch me in...

djackson 22568 (4/23/2012)

---

We can read the original post and think "this is a good thing, it allows companies to hire better people", but only if we ignore the fact that...

Charmer you posted 2 of the 3 requested items and that one is only partially complete. You posted ddl for 4 tables but there is no data for SrcComment.

In your...

While loops are no better (or worse) than a cursor. They should both be avoided except in some rare cases. The example in this post is NOT one of those.

Brandon Leach (4/23/2012)

---

Steve Jones - SSC Editor (4/23/2012)

---

Not sure you need...

Sounds like homework. We are not going to do your homework for you but we can help. What have you tried so far?

As I said before you should look at the first link in my signature. There is no ddl and your sample data is not easily consumable.

The point is we are...

What have you tried so far?

Why are you starting a new thread for the same discussion? If you would post ddl, sample data and desired output you would find lots of people willing to help.

Please...