The simplest solution would be to build the CreditsApplied table and use that. Is that possible?

Add "declare @Err int" to the first proc, then change "exec sp_2" to "exec @err = sp_2".

Try that, and see if it does what you need.

Matt Miller (5/20/2008)

---

GSquared (5/20/2008)

---

Jan Van der Eecken (5/20/2008)

---

I got it wrong, in part because I didn't try it out, but also by relying on the trust I put into the...

I have to ask if you really need to use PatIndex for this. Do you? Wouldn't a join with Like do what you need?

select

contact_id,

contact_firstname, count(*) as...

Try it and load-test it. See if it does what you want.

How many years is it being run over and does the query ever...

I've found using NullIf on the denominator works for many of these cases. Instead of a div-0 error, you get a null result.

select 1/0

Gives div-0 error.

select 1/nullif(0,0)

Gives null result.

It...

I'm not sure why this was set up as a poll. If what you're trying to do is get advice on how to fix this error, I'd rewrite the...

There would be a table lock while it's being renamed, if not a lock on the whole database. That means every time you want to run the rename, you're...

Now that is interesting! Functionally, the table has no purpose except to run that trigger. No data can ever be added to it. What an odd way...

I'd use two separate tables, and a switch to tell the proc which one to look in. (And this should be a case of a master proc that calls...

Someone probably told him that. You'd be amazed what people will start to make up to fill in the gaps in their knowledge.

pduplessis (5/20/2008)

---

Its whatever your preference is.

With the OR statement, you will inadvertently end up writing more letters, but the net effect should remain the same.

Same reads, same amount of scans,...

Jan Van der Eecken (5/20/2008)

---

I got it wrong, in part because I didn't try it out, but also by relying on the trust I put into the SQL team, who...

The answer to both of those questions is you can do them whenever, in whatever sequence.