Forum Replies Created

Viewing 15 posts - 44,146 through 44,160 (of 59,063 total)

  • RE: The T-SQL Paradigm

    andrew gothard (4/15/2009)


    Jeff Moden (4/14/2009)


    Jim Russell (4/14/2009)


    Charles Kincaid (4/13/2009)


    Yes, Pete, many cuts. I saw a paper tape reader on a CDC mainframe that had a gear motor an optical...

  • RE: How to convert INTEGER to TIME

    My bad... looking back on this, I see where you took his suggestion early on. Sorry and thanks for the feedback.

  • RE: How to convert INTEGER to TIME

    So... did any of this solve your problem or not?

  • RE: Performance issue with tally solution

    Lynn Pettis (4/14/2009)


    Everyone on this thread deserves a round of applause (or maybe the theme music from the end of the original Star Wars, unfortunately, I don't have it!).

    Lemme show...

  • RE: Performance issue with tally solution

    RBarryYoung (4/14/2009)


    Jeff Moden (4/14/2009)... this is going to be more fun that trying to catch a vole while wearing silk gloves.

    You have some weird hobbies, dude.

    😛

    BWAA-HAAA!!!! At least I don't...

  • RE: Performance issue with tally solution

    I don't know what anyone else thinks, but this is a freakin' awesome thread. I don't believe such a huge collection of talent and code has ever come together...

  • RE: Performance issue with tally solution

    Florian Reischl (4/14/2009)


    Hi everybody

    Sorry for my late answer but I had a busy day at work...

    Thank you for all your investigations and your time!!!

    I've not been lazy. I did many...

  • RE: Cursors Be Gone!

    Hi Wayne,

    I'm not sure what you mean by "how fast you did the coding". Lots of folks posted and I was just one of them... In fact, I...

  • RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

    Wedge78 (4/14/2009)


    Hi All

    I agree that you can run into problems when using cursors without thought

    However I have an instance where I have to gather information from a 3.2 billion row...

  • RE: The T-SQL Paradigm

    Jim Russell (4/14/2009)


    Charles Kincaid (4/13/2009)


    Yes, Pete, many cuts. I saw a paper tape reader on a CDC mainframe that had a gear motor an optical sensors.

    The optical paper...

  • RE: You have 1,000,000 records in your customers table....

    Steve Jones - Editor (4/14/2009)


    Part of wording the questions is that I have to limit the scope. One way to do that is exaggerate a bit to get you to...

  • RE: Crosstab type report -- Horizontal Summray

    Thank you, Sir. I appreciate the feedback.

    Just in case anyone else reads this thread... see what happens when you give us a little data in a readily consumable format?...

  • RE: Performance issue with tally solution

    Phil Factor (4/14/2009)


    I ran some tests with my own hot-shot generic split-table-function routine.

    Phil, could you post that code here so we have all these fine split functions on one wonderful...

  • RE: Performance issue with tally solution

    David Burrows (4/14/2009)


    looks like I'm gonna have to learn C#.

    Watch out that your halo does not slip too far Jeff 😉

    Heh... Not to worry. I'll wear the tin...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/13/2009)


    I made a slight change to the data loaded. I kept the data the same in both tables this time and here are the statistics io and...

Viewing 15 posts - 44,146 through 44,160 (of 59,063 total)