Forum Replies Created

Viewing 15 posts - 1,246 through 1,260 (of 2,038 total)

  • RE: Are the posted questions getting worse?

    Bob Hovious (4/26/2009)

    It would be the same. Do you think if I went back and edited my post to remove the code, the Thread might forgive me?

    I think...

    April 26, 2009 at 8:54 am

    #984083

  • RE: Are the posted questions getting worse?

    Hi Bob

    Bob Hovious (4/26/2009)

    Never saw the bottle, but you're welcome to anything I ever post up here, as is everyone else. I wouldn't think you'd need my code...

    April 26, 2009 at 8:36 am

    #984080

  • RE: Performance issue with tally solution

    Phil Factor (4/26/2009)

    I've already posted the Quirky and While solutions, but I put the harness in just to make the post more interesting to others.

    Thanks! I will include it into...

    April 26, 2009 at 4:23 am

    #984051

  • RE: Performance issue with tally solution

    Paul White (4/25/2009)

    - no point in re-inventing the wheel, eh? 😉

    One of the hobbies of my chief. We have an own string, DateTime, List, DB-Connection, even an own File... :hehe:

    April 26, 2009 at 4:20 am

    #984050

  • RE: Performance issue with tally solution

    Hi Phil

    This results would be great for cursors! As Paul already wrote could you point me to the "Quirky Update" and "While Loop"? Then I can include it into the...

    April 26, 2009 at 4:17 am

    #984049

  • RE: Performance issue with tally solution

    Paul White (4/25/2009)

    By the way, reading the whole data column (all rows at once) inside the CLR TVF works very well. Splitting that data also works well. However,...

    April 26, 2009 at 4:10 am

    #984047

  • RE: Are the posted questions getting worse?

    Bob Hovious (4/25/2009)

    How about this one? Fresh off the presses...

    And what about this:

    Some colleagues of my company came to me and asked me to have a look to their...

    April 26, 2009 at 3:57 am

    #984046

  • RE: Are the posted questions getting worse?

    GilaMonster (4/25/2009)

    Florian Reischl (4/25/2009)

    The more I learn the more I konw what I do not know

    Psst, Flo, there's typo in your sig.

    Oops...

    Thanks

    Gail!

    April 26, 2009 at 3:42 am

    #984045

  • RE: Are the posted questions getting worse?

    Bob Hovious (4/25/2009)

    Hey Flo:

    I haven't seen anything. When, where, and how did you send it? 🙂

    Hi Bob

    Strange...? I'm sure that the bottle was closed as...

    April 26, 2009 at 3:40 am

    #984044

  • RE: Performance issue with tally solution

    Paul White (4/25/2009)

    Maybe Flo could run 201 tests...? :laugh:

    Pew... I give up with all those static test environments. I currently designed a generic test environment to cover different test at...

    April 25, 2009 at 11:46 am

    #983997

  • RE: How To Compare Duplicate rows

    I'm glad that I could help!

    Best wishes

    Flo

    April 25, 2009 at 9:28 am

    #983971

  • RE: How To Compare Duplicate rows

    Hi

    You can use a partitioned row_number over the field(s) which define the "uniqueness":

    DECLARE @t TABLE (NonUniqueId INT)

    INSERT INTO @t

    ...

    April 25, 2009 at 9:08 am

    #983965

  • RE: Need help creating a loop

    Code (4/23/2009)

    Flo, I LOVE YOU MAN! If anyone ever says you're not cool, I want names!!

    THANKS! 😀

    Code

    :hehe:

    ... the names and maybe the country 😀

    To your problem:

    How many databases do...

    April 25, 2009 at 8:52 am

    #983959

  • RE: Performance issue with tally solution

    Hi Phil

    Phil Factor (4/25/2009)

    I agree that it makes a difference to the CLR results, but it is not a huge difference.

    Sorry, but I disagree. I just tried some of the...

    April 25, 2009 at 8:43 am

    #983958

  • RE: Performance issue with tally solution

    Hey Paul!

    Paul White (4/25/2009)

    Hey Flo!

    These new tally solutions are only fast if all the rows in dbo.JBMTest are identical.

    The QO can tell from the string statistics on the CSV column...

    April 25, 2009 at 8:24 am

    #983955

Viewing 15 posts - 1,246 through 1,260 (of 2,038 total)