A simple one.

A simple integer divide.

How did I miss this command?

Thanks for another good script.

Our business is regulated and we...

Who knew there was so much information in the database.

We haven't solved this problem so we don't archive. We just let the file data grow. Fortunately we have a relatively small set of data, but it is growing. We...

Well that was fun. Thanks.

Thanks for the great article.

Oh, that's why I don't know about it.

James A Skipwith (4/18/2011)

---

Good point Mark, Date would be better here as the time portion is irrelevant. I don't tend to store many dates like this but the Date data...

supriy (6/8/2015)

---

Hi Gail,

Nice article.

However, I have one question. How do you know if an Index is good? I mean we create an index and it works for the query in...

Looks like a fun script. I'll play with it.

The kind of bad data I deal with is data about a person such as birth date, name, SSN. When we bring in data for an existing person that is...

Good article. I often use case in order by. This will give me some new ammunition on how to use it better.