Why do you need to do this in a UPDATE single statement?

Why can't you use a stored procedure or multiple statements in a transaction?

Show us the code that you are using to enter the datetime.

The problem is the second term of the WHERE clause:

WHERE N < LEN(@Parameter)

AND SUBSTRING(@Parameter,N,1) = ','

AND ISNULL(N,0) > 0

)

If N is greater than the length of "@Parameter" then SUBSTRING...

My guess would be that it is the SUBSTRING()'s in your ON clauses.

Heh. Well, the good news is: that one looks easy to fix. 🙂

My thoughts exactly.

Oh, wait, I think I've got it:

SELECT DISTINCT

D.dohid,

RC.RaceCount,

WC.WinCount,

TPM.TotalPrizeMoney,

CASE WHEN ISNULL(RC.RaceCount,0) = 0 THEN 0...

Oops, Seth beat me to it.

Well there's your problem: you changed Seth's Zero-checking CASE function into a Null-checking function. That still let's the Zero's through to the division, thus the error. Assuming...

Seth: Just for clarity, could you post the whole query again, with all of the modifications?

Jack Corbett (11/26/2008)

---

Yup, that is correct. Of course shouldn't you already have a project with the scripts in...

david.x.mcauley (11/26/2008)

---

Thanks again Seth. I'm still hitting that divide by zero error because it looks like for 8 records there is not an rprize1 value for a few races for...

Well the functionality is not too hard, you could either use SMO, which is effectively the API for SSMS (actually, it is the management API for SQL Server, which SSMS...

What would an SSMS Package be?

Please do not cross-post.