Forum Replies Created

Viewing 15 posts - 91 through 105 (of 479 total)

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/24/2009)


    Hahahaha Lynn, Maybe you should not have put Drop Table statements in the end. :hehe:

    Maybe you should edit your post and state that you should not use the...

  • RE: Being More Productive

    Charles Kincaid (3/23/2009)


    Ah. :sigh: I don't like multiple monitors. Get the geometry wrong and you can have stuff positioned between them. I had a coworker fight that for...

  • RE: Being More Productive

    Steve Jones - Editor (3/23/2009)


    The multiple monitors definitely helps me work faster. I have 3 on the desk, struggle slightly when I'm on the laptop.

    My setup is actually using a...

  • RE: Being More Productive

    Multiple monitors, definitely. I currently use 4, 3 hardware and 1 'software'. A few years ago I bought a little client-server application called MaxiVista which allows me to use any...

  • RE: Triggers

    drewsx2 (3/20/2009)


    Thanks Derrick!

    Thnank Barry!

    That works but when I update any other column in that row still executes the email procedure which is fine because the @emailTo is null.

    New problem. It...

  • RE: Are the posted questions getting worse?

    It looks like The Rant has run its course.

    And from his description of his setup (sync software + 3 application tools + 5 databases), I don't think changing things would...

  • RE: Are the posted questions getting worse?

    mazzz (3/20/2009)


    Chris Morris (3/20/2009)


    Beer? Did someone say beer?

    Hey Derek, have you tried the Meantime IPA currently stocked by Sainsbury's yet? Another microbrewery I think. Lovely stuff!

    Is that Sainsbury's, UK?

    If...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/19/2009)


    Derek Dongray (3/19/2009)


    Anyway, while I'm willing to offer some 'keyhole' fixes, I don't want to argue over a redesign of someone else's system (especially as they aren't paying...

  • RE: Triggers

    I'd do this as a JOIN ...

    SELECT

    @EmailTo = i.Name,

    @EmailBody = @EmailBody + CASE ISNULL(v.LastName, '')

    ...

  • RE: Trigger Help! Please

    I'd do this as a JOIN ...

    SELECT

    @EmailTo = i.Name,

    @EmailBody = @EmailBody + CASE ISNULL(v.LastName, '')

    ...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/19/2009)


    Whoa! I think we had an epiphany!!! From The Rant:

    foxjazz (3/19/2009)


    Lynn, you have completely and utterly convinced me to look for a set based solution to...

  • RE: Concatenating field values in one string

    Thanks, Barry.

    Like Lynn, I'd used this trick but not really understood all the details of how it worked. Your explanation is very clear.

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/19/2009)


    I presume it was the first statement.

    What I know of chaos theory leads me to disbelieve the concept of "Temporal Inertia", although conversely it leads me to believe...

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/19/2009)


    Okay.... Sci/Fi people...

    Have you read anything about the concept of temporal momentum or inertia?

    (No, I have no idea where these thoughts come from.)

    In...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/19/2009)


    I left out a few things:

    Cricket bat, hockey stick, bludgeoning devices of all kinds, light sabre's, blasters, fiber optic laser beam assemblers, fiber optic laser beam disassemblers, death...

Viewing 15 posts - 91 through 105 (of 479 total)