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.

jeffrey yao (6/22/2009)

---

I guess this argument is meaningless. We...

You won't find it under tables, you will find it under System Views.

Run this: select name, log_reuse_wait_desc from sys.databases

jeffrey yao (6/22/2009)

---

Michael Valentine Jones (6/22/2009)

---

jeffrey yao (6/22/2009)

I think "no primary keys, no constraints of any kind, no indexes, all columns were nullable, and dates were stored in varchar(8) instead...

And we have another one who can't seem to read.