L' Eomot Inversé (9/17/2012)

---

GSquared (9/17/2012)

---

L' Eomot Inversé (9/15/2012)

---

Unless there is some performance issue that I haven't spotted, it should be sensible to do this the simple and obvious way:

SELECT LoadNumber...

L' Eomot Inversé (9/15/2012)

---

Unless there is some performance issue that I haven't spotted, it should be sensible to do this the simple and obvious way:

SELECT LoadNumber

FROM LoadTimes...

Jeff Moden (9/16/2012)

---

Stefan Krzywicki (9/14/2012)

---

I have two fields of type time. StartTime and EndTime. I want to see if Now is between these two times. For most of the records...

GSquared (9/14/2012)

---

Stefan Krzywicki (9/14/2012)

---

Anyone know how to do this?

Search time type between PM and AM

I can't quite figure out a good way to google it or there's just nothing out...

GSquared (9/14/2012)

---

If EndTime < StartTime, subtract 12 hours from both.

DECLARE @Time1 TIME = '23:00', @Time2 TIME = '01:00';

SELECT DATEADD(hour, -12, @Time1), DATEADD(hour, -12, @Time2);

Edit: You'll have to subtract 12 hours...

Anyone know how to do this?

Search time type between PM and AM

I can't quite figure out a good way to google it or there's just nothing out there on it.

GSquared (9/14/2012)

---

Stefan Krzywicki (9/14/2012)

---

Brandie Tarvin (9/14/2012)

---

Stefan Krzywicki (9/14/2012)

---

GilaMonster (9/14/2012)

---

Anyone get the increasing feeling people are looking for the 'eazy button'?

Case in point:

"I read through those articles [on index column ordering],...

Brandie Tarvin (9/14/2012)

---

Stefan Krzywicki (9/14/2012)

---

GilaMonster (9/14/2012)

---

Anyone get the increasing feeling people are looking for the 'eazy button'?

Case in point:

"I read through those articles [on index column ordering], but I still...

GilaMonster (9/14/2012)

---

Anyone get the increasing feeling people are looking for the 'eazy button'?

Case in point:

"I read through those articles [on index column ordering], but I still want a formula that...

Brandie Tarvin (9/11/2012)

---

Stefan Krzywicki (9/11/2012)

---

Hey Brandie, do you think you're going to WorldCon the next few years? Next year is in San Antonio and the year after is London. I...

Hey Brandie, do you think you're going to WorldCon the next few years? Next year is in San Antonio and the year after is London. I was thinking about the...

Brandie Tarvin (9/7/2012)

---

jasona.work (9/7/2012)

---

Ah, the feeling you get when you do something for yourself, from scratch, without finding someone elses' code to use...

Even if it is something that a seasoned...

dwain.c (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

Why does he have to be so anal all the time? It gets real tiring reading it day after day. I wish SQLTeam would take...

Lynn Pettis (9/6/2012)

---

jcrawf02 (9/6/2012)

---

SQLRNNR (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

SQLRNNR (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

Why do people think that they will get a different answer to the same problem if they post it in the...

Aw, mice! I'll keep practicing. I'm sure I'll get it eventually.