Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 2,443 total)

  • RE: need help with INSERT

    is250sp (10/6/2008)


    jcrawf02 (10/6/2008)


    With the understanding that bit et al replied to OP's request, can I ask a stupid question?

    What is the need for inserting rows with no value into...

    ---------------------------------------------------------
    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: need help with INSERT

    With the understanding that bit et al replied to OP's request, can I ask a stupid question?

    What is the need for inserting rows with no value into the table?...

    ---------------------------------------------------------
    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: Jumping the Gun

    jpowers (10/2/2008)[hrThe other night I switched off a History International program before it was five minutes into the program. The scriptwriter had tried to summarize a complex political situation...

    ---------------------------------------------------------
    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: Jumping the Gun

    Jason Miller (10/2/2008)


    jcrawf02 (10/2/2008)


    Gov't reports on Gov't all the time. Check and balances.

    I think you put far too much trust in there...

    Don't really have another option. I'm not really talking...

    ---------------------------------------------------------
    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: Jumping the Gun

    Jason Miller (10/2/2008)


    jcrawf02 (10/2/2008)


    Maybe instead of the escrow being to the press, there is a third party (more government, I know) that administers these issues and releases findings after a...

    ---------------------------------------------------------
    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: Jumping the Gun

    Steve Jones - Editor (10/2/2008)


    And I do read the DBW, heck, I put them in there. I still see some people commenting they won't stay at a Best Western. BW...

    ---------------------------------------------------------
    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: Jumping the Gun

    You're not reading your own Database Weekly roundup, Steve. http://arstechnica.com/news.ars/post/20080924-does-ideology-trump-facts-studies-say-it-often-does.html from last week says that the damaging press will negatively impact people's perceptions of companies, whether retractions/corrections are printed...

    ---------------------------------------------------------
    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: Understanding INNER join in detail

    http://www.sqlservercentral.com/articles/T-SQL/61539/

    ---------------------------------------------------------
    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: Knowledge Level for Articles

    Steve Jones - Editor (9/28/2008)


    I'm not sure how well this would work. It's one thing when someone intentionally writes for a level, which is what MSDN does, but another when...

    ---------------------------------------------------------
    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: Can I use a Tally table to do this?

    Jeff Moden (9/28/2008)


    jcrawf02 (9/26/2008)


    Normally, that would solve my problem, but I can't create a function. Only temp objects.

    Are you creating a stored procedure or just a script? I need...

    ---------------------------------------------------------
    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: Can I use a Tally table to do this?

    Adrian Nichols (9/26/2008)


    That's okay then, the attached file contains a solution using Dynamic-SQL to pivot the data so that the codeIDs from sequences greater than 1 are concatenated. It'll work...

    ---------------------------------------------------------
    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: Should He Stay or Should He Go?

    Matt Miller (9/26/2008)


    Why people don't actually use probationary periods for what they're designed for (i.e. figure out if someone is a slug, and if they are - they're history) just...

    ---------------------------------------------------------
    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: Can I use a Tally table to do this?

    Adrian Nichols (9/26/2008)


    Hi,

    Is there a defined maximum or a reasonably assumable maximum sequence number?

    upper limit of 23 in the data, although I'm honestly not sure how they snuck that...

    ---------------------------------------------------------
    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: Should He Stay or Should He Go?

    Tracy Wentzler (9/26/2008)


    OMG! What a perfect article for me. I don't know the answer to this one, I am living it right now. I am 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: Should He Stay or Should He Go?

    I agree with majorbloodnock, rmechaber, and all the others who I forgot to note that mentioned that the issue is with Evelyn, not Eric. She didn't want to effectively manage...

    ---------------------------------------------------------
    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,296 through 2,310 (of 2,443 total)