Forum Replies Created

Viewing 15 posts - 781 through 795 (of 2,838 total)

  • RE: Searching the time data type

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 17, 2012 at 10:54 am

    #1538722

  • RE: Searching the time data type

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 17, 2012 at 6:36 am

    #1538560

  • RE: Searching the time data type

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 17, 2012 at 6:35 am

    #1538558

  • RE: Are the posted questions getting worse?

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 14, 2012 at 9:04 am

    #1537919

  • RE: Searching the time data type

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 14, 2012 at 9:02 am

    #1537915

  • RE: Are the posted questions getting worse?

    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.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 14, 2012 at 8:52 am

    #1537901

  • RE: Are the posted questions getting worse?

    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],...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 14, 2012 at 8:16 am

    #1537861

  • RE: Are the posted questions getting worse?

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 14, 2012 at 6:53 am

    #1537796

  • RE: Are the posted questions getting worse?

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 14, 2012 at 6:43 am

    #1537781

  • RE: Are the posted questions getting worse?

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 11, 2012 at 6:59 am

    #1536208

  • RE: Are the posted questions getting worse?

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 11, 2012 at 6:36 am

    #1536194

  • RE: Are the posted questions getting worse?

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 7, 2012 at 11:43 am

    #1535210

  • RE: Are the posted questions getting worse?

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 7, 2012 at 5:56 am

    #1535016

  • RE: Are the posted questions getting worse?

    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...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 6, 2012 at 1:08 pm

    #1534720

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/6/2012)

    Stefan Krzywicki (9/6/2012)

    ...

    watermellon meatloaf

    Doesn't quite work... :w00t:

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

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 6, 2012 at 11:26 am

    #1534658

Viewing 15 posts - 781 through 795 (of 2,838 total)