Forum Replies Created

Viewing 15 posts - 45,826 through 45,840 (of 59,063 total)

  • RE: Why do people need to do this?

    Lynn Pettis (1/16/2009)

    The excuse I usually here is this:

    It's easier to create and transfer one file instead of multiple files.

    Now THAT I get! It's a bit strange in how...

    January 16, 2009 at 3:14 pm

    #928555

  • RE: Why do people need to do this?

    Lowell (1/16/2009)

    clearly any data without an arbitrary number next to it is worthless! everyone knows that! how else do you know who's number 1, or to give a goals to...

    January 16, 2009 at 3:11 pm

    #928552

  • RE: Why do people need to do this?

    Matt Miller (1/16/2009)

    If you were a marketing person for CDW - knowing what the top five selling products are within each sales department would be something important. The last...

    January 16, 2009 at 3:09 pm

    #928548

  • RE: Why do people need to do this?

    Luke L (1/16/2009)

    ...to put into a flat file full of repeating groups to send to another organization.

    Heh.. that's what you did... my question would be, why did they want it...

    January 16, 2009 at 3:05 pm

    #928546

  • RE: Evaluate a string Expression

    ramsatish (1/15/2009)

    Hi Michael Earl ,

    Thank you for the quick reply.

    How we are going to achieve this using CLR procedure.

    Is there any method/funtion available in CLR(SSIS) like "eval" to evaluate a...

    January 16, 2009 at 2:29 pm

    #928532

  • RE: Evaluate a string Expression

    ramsatish (1/15/2009)

    Hi,

    I have a table which has expression as a column and the data looks similar to the following .

    ID (int) ...

    January 16, 2009 at 2:16 pm

    #928523

  • RE: SQL or Oracle

    hb21l6 (1/16/2009)

    It would appear that I have made a bit of a stir with this question. Sorry all,

    I think I’ll just stick at my MS SQL. Should be ready to...

    January 16, 2009 at 1:34 pm

    #928497

  • RE: Hidden RBAR: Triangular Joins

    Caleb (1/16/2009)

    Thanks Jeff. In your example, I presume everyone would be running around trying to figure out why tempdb was filling up and without 2005's dmvs would find that task...

    January 16, 2009 at 1:26 pm

    #928493

  • RE: Which SQL would run faster?

    leonp (1/16/2009)

    ok now that things are returning to normal do we think ISNULL performing better than COALESCE for checking a single operand is no co-incidence?

    I don't believe they intentionally did...

    January 16, 2009 at 1:08 pm

    #928480

  • RE: Phone Numbers Table Design

    Krishna_DBA (1/16/2009)

    According to Abhijits design, I would have to create 6 unique ID's If a particular customer has 6 work phone numbers. is that right??

    That's correct... and you shouldn't have...

    January 16, 2009 at 1:03 pm

    #928471

  • RE: Phone Numbers Table Design

    By the way... if you do contact CCMI, the wizard behind the curtain that makes it all work is called Ed Sullivan. Laugh if you want, that's his real...

    January 16, 2009 at 1:00 pm

    #928469

  • RE: Phone Numbers Table Design

    Jack Corbett (1/16/2009)

    Interesting, Jeff. I am in process of developing a system that needs to handle international phone numbers and we decided to go with this design:

      Countries (country_code (iso),...

      January 16, 2009 at 12:56 pm

      #928463

    • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

      By the way, Julie... what does the prefix "Wrt" stand for?

      January 16, 2009 at 12:33 pm

      #928447

    • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

      Very cool and great explanation of the problem you were trying to solve. Thanks a huge amount for taking the time to post it, Julie! 🙂

      January 16, 2009 at 12:27 pm

      #928442

    • RE: Which SQL would run faster?

      GilaMonster (1/16/2009)

      Jeff Moden (1/16/2009)

      I'm trying to be as nice as pie... I don't understand why people post code and ask which will be faster... that's pretty lazy...

      Cause it's easier...

      January 16, 2009 at 12:22 pm

      #928437

    Viewing 15 posts - 45,826 through 45,840 (of 59,063 total)