Forum Replies Created

Viewing 15 posts - 3,556 through 3,570 (of 5,502 total)

  • RE: Killer query, too muc for t-sql

    Please have a look at Jeff Moden's "Running Total" article[/url].

    I think it's the best performing apporach. But you need to understand the requirements in order to get consistent results....


    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]

    May 11, 2010 at 11:25 am

    #1165720

  • RE: checkning for allowable values

    Jeff Moden (5/10/2010)

    As much as I love working with the Tally table, it just doesn't need to be that complicated for this. In fact, the CASE formula in the...


    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]

    May 11, 2010 at 10:44 am

    #1165692

  • RE: Create a table from another table for multiple values

    Please provide the table definition (DDL script), some sample data (INSERT ...SELECT), your expected output related to the sample data, what you've tried so far and where you get stuck.

    For...


    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]

    May 11, 2010 at 10:36 am

    #1165683

  • RE: Concatenating with conditional delimiter

    Glad I could help 😀


    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]

    May 10, 2010 at 2:42 pm

    #1165241

  • RE: Concatenating with conditional delimiter

    Here's a slightly different apporach (using the sample data Cory set up):

    I prefer STUFF over SUBSTRING for scenarios like this since it's a little less coding and it doesn't include...


    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]

    May 10, 2010 at 2:26 pm

    #1165229

  • RE: checkning for allowable values

    You might want to have a look at the Tally table article referenced in my signature. There is a split string function included you could modify to meet your requirements.

    This...


    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]

    May 10, 2010 at 2:09 pm

    #1165222

  • RE: Plz let me know what cause it will come alert

    duplicate post.

    Discussion already started here


    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]

    May 10, 2010 at 1:50 pm

    #1165215

  • RE: Node.value and insert the result to an existing table

    Ok, here's how I'd do it:

    DECLARE @tbl TABLE

    (

    UserID INT ,

    Email NVARCHAR(50) ,

    Pass NVARCHAR(20) ,

    FirstName NVARCHAR(20) ,

    LastName NVARCHAR(40) ,

    DisplayName NVARCHAR(50) ,

    PROFILE NVARCHAR(MAX) ,

    DisplayEmail NVARCHAR(50) ,

    CellPhone NVARCHAR(20) ,

    UpdatedBy INT ,

    UpdateDate DATETIME ,

    Deleted...


    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]

    May 10, 2010 at 1:19 pm

    #1165194

  • RE: Adding row and column totals to a dynamic pivot table

    I wonder how you actually can provide really fast SAAS solutions without having a Tally table available 😀

    Would be interesting to have a small talk with your admin...

    One thing...


    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]

    May 9, 2010 at 2:47 am

    #1164675

  • RE: Node.value and insert the result to an existing table

    Would you please provide some sample data to play with?

    Basically, a sample xml file with the structure you're faced with holding FAKE data and your target table with a few,...


    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]

    May 8, 2010 at 12:58 pm

    #1164599

  • RE: Node.value and insert the result to an existing table

    Store the shredded xml data into a relational (temp) staging table.

    Use this table and check for existing emails within your insert statement.


    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]

    May 8, 2010 at 5:12 am

    #1164549

  • RE: Using " IN " inside " WHERE " clause

    You would nee to provide an ORDER BY clause based on a column that will hold any order criteria.

    Since SQL Server does not perform a row-by-row processing, it will select...


    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]

    May 8, 2010 at 4:55 am

    #1164546

  • RE: Dynamic Query/sproc

    alex abenitez (5/5/2010)

    I don't know how many fields it will be but I expect it to be less than 30.

    Did you have the time to read the articles I mentioned...


    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]

    May 8, 2010 at 4:46 am

    #1164545

  • RE: Adding row and column totals to a dynamic pivot table

    Jeff Moden (5/8/2010)

    ...

    If we modifed the code to work as you desired, you would not be able to support it because you don't understand the content of the article. ...


    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]

    May 8, 2010 at 4:20 am

    #1164543

  • RE: Are the posted questions getting worse?

    GilaMonster (5/7/2010)

    ...

    No. Thesis is due end of the year and it's going to take til the end of the year. I have no classes or exams, haven't had since the...


    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]

    May 7, 2010 at 5:15 pm

    #1164506

Viewing 15 posts - 3,556 through 3,570 (of 5,502 total)