hallidayd (10/20/2010)

---

Hello

In order to make use of an index.... AND date_time >= '20090901'

AND date_time < '20091001'So those are your start and end times hard coded. Exactly how we parameterise...

Paul White NZ (10/20/2010)

---

GSquared (10/20/2010)

---

I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages of either. It's a "worst of...

How are you inserting into the text column? Are you bulk importing, or doing something else?

Inserting text can't result in SQL injection unless you're using dynamic SQL to do...

Oliiii (10/20/2010)

---

paul.knibbs (10/20/2010)

---

Steve Jones - SSC Editor (10/19/2010)

---

I think there's a little elitist mentality, but someone ought to know how to do this in scripting. It's much more efficient, especially...

You're welcome.

Jeff Moden (10/19/2010)

---

Steve Jones - SSC Editor (9/21/2010)

---

Paul White NZ (9/21/2010)

---

...

The current SQL development model is to address a small number of main product features in each new major release....

Steve Jones - SSC Editor (10/19/2010)

---

WayneS (10/18/2010)

---

... we need several hundred years of records to know this, and we barely have one hundred. I also believe that this whole global...

jcrawf02 (10/19/2010)

---

Personally, I think being "green" is just a responsible way to be. Politics aside, and regardless of whether global warming is or isn't happening, being more efficient and less...

Sounds like you're approaching it the right way. That's pretty standard and works as expected.

Eric Russell 13013 (10/18/2010)

---

GSquared (10/18/2010)

---

SanDroid (10/12/2010)

---

David Walker-278941 (10/12/2010)

---

I originally didn't like GUIDs because I thought they used too much "space". They really don't. Disk space is cheap, and...

Sounds like a good plan.

If you do have trouble getting paid, and trouble getting a valid reason for that, make sure you publish the name of the offending company somewhere,...

Take a look at this article, and at the referenced material by Joe Celko. It will probably help you figure out how best to build the hierarchy in your...

Since you definitely know more about this than I do, I'll bow out on this one.

True. A sort operation on a small dataset is trivial. Can you guarantee the dataset will always be small? Scalability is one of the keys to good...

You're welcome.