I would also ask what exerience you currently have regarding IT?

Just because it didn't work for...

David.Poole (1/23/2009)

---

I'm just wondering what situation exists where you have 1 billion records with a tiny proportion having a bit field set to 1 AND that field being important enough...

Jeff Moden (1/26/2009)

---

Lynn Pettis (1/26/2009)

---

Cardinal Moden is an excellent resource in the fight against RBAR. I must admit to having learned quite a bit from his excellent mentoring via...

Cardinal Moden is an excellent resource in the fight against RBAR. I must admit to having learned quite a bit from his excellent mentoring via SSC.

Sometimes REPLACE isn't the right tool for the job. I agree with Jeff, just convert to an INT.

Double posted. Please post further responses here.

Please do not double post as it fragments the responses you receive.

Please post responses here.

Please don't triple post. Those who will respond to your request for help watch all new posts.

In addition if fragments the responses.

Please answer here.

Please don't triple post your questions. Most people who will help you watch all new posts.

In addition it fragments the responses you do receive.

TheSQLGuru (1/23/2009)

---

>>Ditto ISO standard data. If there is an international standard use it.

If there is no international standard conform to an industry standard

>>

I will take the contrary position here....

LeeBear35 (1/22/2009)

---

TheSQLGuru (1/22/2009)

---

>>Any DBA who thinks an index on a bit field is a good idea.

You have a billion row table, with from 0 to 100 rows at any one...

Wrong, 1 month. This will also return 1: datediff(mm,'2009-01-31','2009-02-01').

Peso wrote an excellent article on datediff. You can find it on SQLTeam.com.

Gotta be the optimist sometimes and hope someone wins at least once.

Garadin (1/21/2009)

---

Jeff Moden (1/21/2009)

---

Garadin (1/20/2009)

---

Michael Valentine Jones (1/20/2009)

---

In the end, does the reason why really matter?

We had a meeting where we objected to a project as complete waste time and...

Fish, we gotta have fish too (even though I don't eat fish).