Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 5,678 total)

  • RE: Determining Continuous Eligibility between dates

    What are you expecting for results? Also, could put that into a consumable format as described in the first link in my signature? It'll help us give you...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: interactive package in SSIS?

    herladygeekedness (6/21/2012)


    I would love more info on how to add conditional logic to a SQL Agent job as I have not found that functionality and could certainly put it to...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Add invoice in stored procedure

    3935 (6/21/2012)


    Any idea out there ?

    Heya there, and welcome to the forums. If you'll take a look at the first link in my signature below, you'll see a recommendation...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/21/2012)


    OMG

    Please, I really hope this person was joking.

    Um, that's Charmer, nothing new there. He's always had a very difficult time with the English language, enough that it...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    L' Eomot InversΓ© (6/20/2012)


    The thread seems very quiet. I've been away three days and there are only 62 new posts on it.

    But I may not find...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Record Matching in FIFO Basic in Stock data

    You most likely want to work off the lot inventory instead off the transactions list because you have to resum all sells to determine what tax lot you're involved with...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Showing Sum in the last row

    Jeff Moden (6/18/2012)


    But, do you know your business? Can your "code" support the required spreadsheet for some, the "report" for others, PowerPivot or other DW based system...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Delete Trigger

    Jan Van der Eecken (6/18/2012)


    I know πŸ˜‰

    Mmmmm... tasty foot. Anyone want a bite? :pinch:

    One of those days... :Whistling:


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    WayneS (6/18/2012)


    I'll be starting the new job in a couple of weeks. I'll be a DBA with a small company that some of you'll in the northeast corridor might have...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Delete Trigger

    Jan Van der Eecken (6/18/2012)


    Evil Kraig F (6/18/2012)


    Jan Van der Eecken (6/18/2012)


    Oops, I misspelled your name. Apologies, Kraig!

    LOL, at this point, either is acceptable. πŸ˜‰ :w00t:

    It just depends...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (6/18/2012)


    And JC went off on a rant again..

    Meh, I can't be bothered to de-rant him this time. Someone else do it...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Delete Trigger

    Jan Van der Eecken (6/18/2012)


    Oops, I misspelled your name. Apologies, Kraig!

    LOL, at this point, either is acceptable. πŸ˜‰ :w00t:

    It just depends on which of the twins you want...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Delete Trigger

    Jan Van der Eecken (6/18/2012)


    If you run

    select * from sys.sysprocesses WHERE spid = @@SPID

    does it give you what you need to know in the nt_domain and nt_username columns? I'm running...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Showing Sum in the last row

    Hope you don't mind if I chime in on this discussion Jeff. πŸ™‚

    Jeff Moden (6/18/2012)


    SQLKnowItAll (6/18/2012)


    So, when working with a set of data I believe it is much easier and...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Comparing execution time of table valued function.

    kharol (6/18/2012)


    Duncan:

    I thought about parameter sniffing, but all resource I found about it was related to stored procedures. Nevertheless, I tried wrapping it in stored procedure that would do exactly...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 15 posts - 1,441 through 1,455 (of 5,678 total)