Forum Replies Created

Viewing 15 posts - 2,581 through 2,595 (of 5,502 total)

  • RE: column value balancing (copy previous value <> NULL)

    WayneS (11/17/2010)

    ...

    I knew there was something I was going to add to my post - THANKS LUTZ!

    ...

    It took 3 whole seconds on your system? What'd you do, kick off a...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 17, 2010 at 3:49 pm

    #1252198

  • RE: column value balancing (copy previous value <> NULL)

    @Dick: VERY IMPORTANT!!!

    Based on your previous note "4. No clustered index yet " Do NOT run the code until you added a clustered index that supports the order the data...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 17, 2010 at 3:12 pm

    #1252181

  • RE: column value balancing (copy previous value <> NULL)

    Great job, Wayne!

    That's the solution I had in mind... 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 17, 2010 at 2:38 pm

    #1252166

  • RE: column value balancing (copy previous value <> NULL)

    WayneS (11/17/2010)

    Dick Herberts-320552 (11/17/2010)

    Hi ,

    Wow , sounds too good to be true. Do you have an example , Please help

    Regards,

    Dirk

    @? Is your name Dick, or Dirk?

    Can you verify also:

    1. That...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 17, 2010 at 11:42 am

    #1252070

  • RE: Question on Recursive

    Craig Farrell (11/17/2010)

    biren (11/17/2010)

    Hello,

    This works thank you very much... A ++ SUPPORT !!

    Support? We get paid for this? *scratches head* Hey, Steeeeeeeve..... where's my check dood?!

    Depending on...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 17, 2010 at 11:39 am

    #1252068

  • RE: column value balancing (copy previous value <> NULL)

    You might want to read the first article linked in my signature on how to post sample data.

    Please include the clustered index definition, since it's crucial to decide which option...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 17, 2010 at 11:29 am

    #1252055

  • RE: Question on Recursive

    Here's the Cross Join syntax together with the string concatenation.

    As a side note: I had to modify your sample data script to actually work. It's good practice to test such...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 17, 2010 at 12:42 am

    #1251709

  • RE: Populating a new column in a SQL2K table with incremental numbers by row

    There are basically two approaches:

    1) insert the data into a new table with an IDENTITY column to get consecutive New_ID's (maybe using an auxiliary column to get it formatted properly)...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 16, 2010 at 4:06 pm

    #1251639

  • RE: Question on Recursive

    You might want to start with CROSS JOIN on those three tables.

    Unfortunately, there is no rule that would explain why there is no entry for

    BrandNameTwo ProductNameOne aviator eyewear

    or any...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 16, 2010 at 4:00 pm

    #1251633

  • RE: Using Group By and Case I need a column to output in all situations

    I'm not sure if it's th fastes possible solution, but here's how I'd do it:

    Step 1: get the list of distinct AccountID's

    Step 2: Build a "master list" by cross referencing...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 16, 2010 at 3:55 pm

    #1251628

  • RE: dec to hex

    rokuba (11/16/2010)

    link

    Spam reported.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 16, 2010 at 2:58 pm

    #1251610

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/16/2010)

    Steve Jones - SSC Editor (11/16/2010)

    We have a new saint?

    False alarm. What they thought was a halo turned out to be a toilet seat. 😀

    (Just kidding)

    ROTFLMAO


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 16, 2010 at 2:41 pm

    #1251598

  • RE: How to code to list columns' name for one table separate by ','?

    adonetok (11/16/2010)

    Thank you again for your advice.

    The only thing I do not understand is "FOR XML PATH('')". What is use for?

    Did you try to run the statement step by step?

    Something...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 16, 2010 at 12:19 pm

    #1251540

  • RE: Are the posted questions getting worse?

    Chris Morris-439714 (11/16/2010)

    Am I being too harsh with this poster?

    If what you did over there would be considered being harsh, I'd have to stop posting!!

    The effort you put in goes...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 16, 2010 at 11:52 am

    #1251521

  • RE: How to code to list columns' name for one table separate by ','?

    WayneS (11/16/2010)

    One thing that is missing from the query is ordering. Do you want the column names ordered alphabetically, or by their position in the table, or is random acceptable?

    Good...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 16, 2010 at 11:29 am

    #1251510

Viewing 15 posts - 2,581 through 2,595 (of 5,502 total)