Viewing 15 posts - 20,326 through 20,340 (of 26,490 total)
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
June 23, 2009 at 9:51 am
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...
June 23, 2009 at 9:40 am
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...
June 23, 2009 at 9:13 am
Is the user an owner of any schema's in the database?
June 23, 2009 at 8:18 am
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...
June 23, 2009 at 8:07 am
RBarryYoung (6/23/2009)
Lynn Pettis (6/22/2009)
How about this one? 😛Now I'm being called a troll.
Really now, shouldn't that be Saint Troll?? 😉
Actually, I suspect that that's little Snarky trying to tip-toe...
June 23, 2009 at 4:17 am
The image data type is being depreciated and the varbinary data type should be used instead.
June 22, 2009 at 10:57 pm
Jeff Moden (6/22/2009)
Lynn Pettis (6/4/2009)
June 22, 2009 at 9:47 pm
Hard to vote it is. Some system use maintenance plans, others are roll your own. No option to vote both ways.
June 22, 2009 at 9:02 pm
Gift Peddie (6/22/2009)
Gift Peddie (3/18/2009)
June 22, 2009 at 8:59 pm
That is because decimal(8,8) means this: .00000000. You need to define your decimal value more like this: decimal(32,8).
June 22, 2009 at 8:47 pm
June 22, 2009 at 8:42 pm
unknown (6/22/2009)
thank you I was just trying to help. I see this site is full of trolls.
Pardon?? I was pointing out that a particular post was simply an echo...
June 22, 2009 at 8:36 pm
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...
June 22, 2009 at 8:29 pm
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.
June 22, 2009 at 8:21 pm
Viewing 15 posts - 20,326 through 20,340 (of 26,490 total)