Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 2,443 total)

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/12/2008)


    Lynn Pettis (12/12/2008)


    So, having noticed items 2 through 4, where do you fall?? Also, I may be an old fart, but I can keep up with high school...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: random integer number scalar function

    Thanks, and understood. I think this will be fine for our purposes, and we're mostly on 2000 at the moment, so hashbytes() won't help me until we upgrade.

    Thanks again,

    Jon

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Lynn Pettis (12/12/2008)


    So, having noticed items 2 through 4, where do you fall?? Also, I may be an old fart, but I can keep up with high school students...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    lol y'all are nuts. I haven't checked in on this thread for a while, last time it was actually related (more or less) to the title, now I come back...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: random integer number scalar function

    Great timing Chris, I was just looking for something that would allow me to generate random numbers.

    Jeff, based on your code for random test data, I had been playing with...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

    Jeff Moden (12/3/2008)


    jcraddock (12/3/2008)


    I've had better luck writing code that writes my SQL. I wrote a set of code that you point at any table, it accepts any column...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Select columns by ordinal position?

    Don't know if you really wanted to get this involved, but check Phil Factor and Robyn Page's article out:

    http://www.simple-talk.com/sql/t-sql-programming/sql-server-matrix-workbench/

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Alone Time

    Carla Wilson (12/11/2008)


    Matthew Joughin (12/11/2008)


    I use a free service called rescue time to monitor how much work I'm actually doing

    http://www.rescuetime.com

    it is really awesome, and helps me make sure that i'm...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Data Vices

    Steve - glad to see somebody mention BFL, I loved it myself, but then I got remarried, lazy, and now I need to go again. Best I've ever felt, and...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: T-sq doubt

    Chris Morris (12/9/2008)


    Garadin (12/9/2008)


    Chris Morris (12/9/2008)


    You tell us. There are no mindreaders here.

    I knew you were going to say that.

    Thanks Seth made me larf that did! Now, about the...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Alone Time

    Robert Hermsen (12/10/2008)


    I especially like the upgrading to wife and family 2.0

    I agree, that shows real committment to his work!

    :hehe:

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: What S.M.A.R.T. goals should I list in my evaluation?

    Liz Ofstad (11/24/2008)


    I want to learn as much as I can and be as helpful as possible to the team but that's not really a measurable goal.

    Depends...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Calculating Age

    To add a comment that is to Lynn's point of "Use the solution that fits your situation"; I happen to be looking for the age in months in order to...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: remove sql server date time default value

    Charles Kincaid (12/1/2008)


    Jeff Moden (11/29/2008)


    Some folks store unknown or "open" dates as 99991231 so they don't have to check for null to see if an enddate has occurred in the...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: The Ebb and Flow of Community

    The great thing about SSC is that even if you know you're not one of the experts, but think you can help, you can post what you know, and without...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 15 posts - 2,221 through 2,235 (of 2,443 total)