Forum Replies Created

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

  • RE: Query for Emp Time Logging

    That could be easily fudged with a CASE around the selection of the Duration column. But I don't think that's the OP's intention.

    So, George, you say this is a...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 16, 2013 at 4:09 am

    #1624419

  • RE: Simple Program

    Glad it helped you out 😉

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 16, 2013 at 1:00 am

    #1624416

  • RE: Grouping by day on a rollover count

    Hi Brett,

    Seems you are slogging around and getting somewhere step by step. It would however be very useful if you were to post DDL for the tables involved, plus some...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 15, 2013 at 5:10 pm

    #1624402

  • RE: SSIS FTP Task - Adding Date Critiera.

    Hi,

    I'm not an SSIS expert, so I'd suggest reposting your question on the Integration Services forum which you can find under Data Warehousing on this site. I'm sure you'll have...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 15, 2013 at 4:32 pm

    #1624401

  • RE: Query for Emp Time Logging

    Looking (or rather guessing) at the problem statement, Wolfgang's query should do the right thing, but it wont give the right result for Alen since it will show 49 minutes...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 15, 2013 at 4:17 pm

    #1624400

  • RE: Simple Program

    Hehe, I beat you to it Tom 🙂

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 15, 2013 at 4:03 pm

    #1624397

  • RE: Simple Program

    I'm guessing here because your requirements aren't quite clear. What you seem to want to do is to set the Type column to either 'OK' or 'NOTOK', based on whether...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 15, 2013 at 3:59 pm

    #1624395

  • RE: Need to select specific Application version if machine has multiple times same application installed

    Hi Denis,

    First of all, it is always a good idea to post DDL (in other words scripts to put the table structures together) and a set of sample data (as...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 15, 2013 at 3:23 pm

    #1624392

  • RE: Are the posted questions getting worse?

    ... Maybe the absence of a right fielder in the lineup is a nod to the common perception of right field as a "throwaway" position that's not very important to...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 15, 2013 at 1:28 pm

    #1624384

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/14/2013)

    ***************************************************

    I am officially going to Afghanistan!

    I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving there...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 15, 2013 at 1:19 pm

    #1624382

  • RE: Are the posted questions getting worse?

    dwain.c (6/13/2013)

    Sean Lange (6/13/2013)

    WayneS (6/13/2013)

    dwain.c (6/12/2013)

    I can only imagine what it must be like to have SQL Server running in some non-English language. MS probably translated the obtuse into...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 14, 2013 at 2:50 am

    #1623995

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (6/13/2013)

    A Dr. Who reference worked into a classic comedy routine by Abbott and Costello, Gail.

    http://www.youtube.com/watch?v=J_gSWTQKE-0

    Unfortunately, you have to know something about baseball to...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 13, 2013 at 10:12 am

    #1623808

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/13/2013)

    SQLRNNR (6/13/2013)

    Brandie Tarvin (6/13/2013)

    jasona.work (6/13/2013)

    Why can I picture something like that actually being buried in the depths of the SQL / SSIS code?

    One of those little "bored programmer"...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 13, 2013 at 10:10 am

    #1623806

  • RE: How have Trigger's example after insert send to mail on outlook?.

    pinakid4u (6/3/2013)

    would this code runs on mysql successfully, please help me.

    No.

    Please, remember this is an MS SQL forum. You better ask this question on a MySQL forum in order to...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 4, 2013 at 4:18 am

    #1620857

  • RE: Are the posted questions getting worse?

    wolfkillj (6/3/2013)

    I heard a great joke for nerds (I was about to call it "nerd joke", but it's for nerds, not about nerds) this weekend:

    Why do computer science majors always...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 3, 2013 at 3:35 pm

    #1620732

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