Forum Replies Created

Viewing 15 posts - 961 through 975 (of 5,685 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...

    November 29, 2012 at 3:19 pm

    #1564073

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

    November 29, 2012 at 3:05 pm

    #1564067

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

    November 29, 2012 at 1:58 pm

    #1564040

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

    November 29, 2012 at 12:56 pm

    #1563997

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

    November 29, 2012 at 12:46 pm

    #1563994

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

    November 29, 2012 at 12:43 pm

    #1563990

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

    November 29, 2012 at 11:59 am

    #1563958

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

    November 29, 2012 at 11:48 am

    #1563954

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

    November 29, 2012 at 11:39 am

    #1563949

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

    November 29, 2012 at 1:20 am

    #1563594

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

    November 29, 2012 at 1:16 am

    #1563593

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

    November 28, 2012 at 4:40 pm

    #1563512

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

    November 28, 2012 at 3:48 pm

    #1563494

  • RE: Today's Random Word!

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

    Z machine

    Rube Goldburg

    November 28, 2012 at 3:11 pm

    #1563482

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

    November 28, 2012 at 3:06 pm

    #1563478

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