Too many parens in your SQL version. Try this:

alter function dbo.upper95(@P float, @N float)

returns float

as

begin

return @P+1/@N+2*SQRT((@P*(1-@P)/@N)+1/(2* POWER(@N,2)))/(1+2/@N)

end

go

Always room for more. Welcome aboard!

I would also recommend reading the first two articles I reference in my signature block below. You may also find yourself recommending these...

A block of salt would be better. Use it as a guide to determine what indexes may be needed. Review them carefully, you may find several that can...

Is the user an owner of any schema's in the database?

Here is another solution that I think is a bit simplier, but since I seem to be having a problem (again) posting the code directly in the thread, it is...

RBarryYoung (6/23/2009)

---

Actually, I suspect that that's little Snarky trying to tip-toe...

The image data type is being depreciated and the varbinary data type should be used instead.

Jeff Moden (6/22/2009)

---

Lynn Pettis (6/4/2009)

---

You could also give sswug.org a try, if you want to pay for membership. They seem to try and cover everything, not just MS SQL...

Hard to vote it is. Some system use maintenance plans, others are roll your own. No option to vote both ways.

Gift Peddie (6/22/2009)

---

Gift Peddie (3/18/2009)

---

There was the forums by Revealnet in Chicago but Quest bought it and shut the site and just send useless emails with their list. So...

That is because decimal(8,8) means this: .00000000. You need to define your decimal value more like this: decimal(32,8).

How about this one? 😛

Now I'm being called a troll.

Really now, shouldn't that be Saint Troll?? 😉

Pardon?? I was pointing out that a particular post was simply an echo...

Here is another solution, you'll have to try them all out.

CREATE TABLE dbo.InsuranceClaim(ClaimNumber INT)

INSERT INTO dbo.InsuranceClaim VALUES (1)

INSERT INTO dbo.InsuranceClaim VALUES (2)

INSERT INTO dbo.InsuranceClaim VALUES (3)

INSERT INTO dbo.InsuranceClaim VALUES (4)

INSERT...

select

cast(convert(decimal,a.totaltransactions) / nullif(convert(decimal,b.totaltransactions),0.00) as decimal (8,8))

from

table1

Last time I tested, dividing by null returns null. Give this a try.