Forum Replies Created

Viewing 15 posts - 961 through 975 (of 5,678 total)

  • RE: Find Price Changes in Item History Table

    irobertson, I agree with this would usually smell like a HW question, but for homebrew I can assure you it isn't. 🙂 Sometimes being a regular lets you simplify...


    - 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: SSIS oddness

    Containers can have some options that can mess with connections, like transactions, but it doesn't sound like you activated them. Go to the sequence containers and make sure they're...


    - 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: Select query to determine unique values

    If you'll take a look at the first link in my signature it'll show you what we'd prefer to be able to help you with coding problems like this. ...


    - 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: Exercises in t-SQL

    Steven Willis (11/29/2012)


    BTW, a carpenter doesn't work without a toolbox and neither do I. If I was looking for a serious candidate I'd expect that he could not only Google...


    - 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: Find all columns that might contain SSN numbers

    Grab paddle, proceed up creek.

    There's really no way to do what you're looking for, primarily because of the part that's frustrating you, the lack of a dedicated pattern.

    You could, in...


    - 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: Identify objects in all the databases which are using specific column as the filter (where condition)

    Sean Lange (11/29/2012)


    This would meet your criteria of having a where clause and the word "Regulatory" somewhere later in the string. The point I am making is what you are...


    - 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: Building Expressions

    sasansamani (11/29/2012)


    maybe I am not explaining this correctly.

    I'm afraid I don't have an answer for you but I don't believe the problem is the explanation per se. It's just...


    - 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: Recursion with a Twist

    Phil Parkin (11/29/2012)


    I wrote the above response before trying Craig's solution, which certainly does the business - thanks! Maybe this is one instance where a loop is the best solution....


    - 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: Pointing to a Particular Data Flow Task from a Script Task

    Mordred (11/29/2012)


    Thanks so much as this worked quite well. The expression didn't like User:: so I went with @Table_Number=="3790027" which was accepted.

    My pleasure. Sorry, some require the User::...


    - 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: managing huge data in database?

    sumith1andonly1 (11/28/2012)


    Any one can suggest a solution to this problems ?

    A couple of things suggest themselves offhand.

    We have database 'testDb' with 5 tables.

    mainly 'user_details_tab' and 'user_deatils_backup_tab'.

    The database 'testdb' filled 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: Recursion with a Twist

    thava (11/29/2012)


    how about this one

    It can't go backwards from 3 to get back to 1 because of the limitor to reduce duplication and endless recursion. It's similar 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: Today's Random Word!

    Revenant (11/28/2012)


    Evil Kraig F (11/28/2012)


    L' Eomot Inversé (11/28/2012)


    Z machine

    Rube Goldburg

    Goldberg?

    :blush: Ayup.


    - 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: Am I dropping records?

    jimgleason512 (11/28/2012)


    Again, a helpful response. Thanks.

    My pleasure. I'm always happy to help those who are willing to put in the time first and just get stuck. We...


    - 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: Today's Random Word!

    L' Eomot Inversé (11/28/2012)


    Z machine

    Rube Goldburg


    - 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: Recursion with a Twist

    Alan.B (11/28/2012)


    Evil Kraig F (11/28/2012)


    This is NOT pretty, but it IS functional.

    I am trying to understand why went with a loop vs a set-based approach. I posted a more set...


    - 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 - 961 through 975 (of 5,678 total)