Eliminate the loop?

Then I guess the core question is, what's the...

You can simply put the statement RETURN in the IF statement like this:

IF (@a = 0) AND (@b = 0)

BEGIN

RETURN

END

ELSE

BEGIN

SELECT....

END

But, you'd be better off returning a value of some sort,...

I'm going to pile on a bit and agree with Jeff. When you have views calling views that are joined to views, you will begin to get very poor execution...

There's no real way to limit access of a given database to memory or cpu on the server. If you have a badly performing database, you'll need to isolate it...

You need to also pass in the owning schema of the table as @table_owner.

I'm afraid I don't understand the question. Can you expand on it a bit?

Use the TRY/CATCH construct. It provides the most power for what you need. There's an introductory article here[/url].

Just for curiousity, what did you do to solve the performance issue?

I see a function on a column in the WHERE clause that will prevent index use. Was that it?

None that I'm immediately aware of. I'd have to do a search for it.

jcrawf02 (9/25/2009)

---

I got this picture in my head of Grant in mountaineering gear on the slopes of Everest as he passes Alvin...

And there's...

Roy Ernest (9/25/2009)

---

Maybe we should make a forum in SQL Pass where the chapter leaders can exchange ideas? You know what I we like to have for our pass chapter?...

Alvin Ramard (9/25/2009)

---

Grant Fritchey (9/25/2009)

---

I just fired off a message to Greg Low, the board member that manages chapters, to see what we've got available, if anything. Great question. Why...

Yeah, it'll convert an int parameter to a bigint... but, what happens the first time you pass a bigint to the int parameter? You're going to have to update those...

I just checked with our systems guys, they say it's possible, but they've never done it and don't recommend it.