Forum Replies Created

Viewing 15 posts - 2,116 through 2,130 (of 5,502 total)

  • RE: Need help with query to generate a Matrix

    Almost understood.

    In your initial post you stated

    My matrix needs to have the count of people that changed groups duing the month.

    Referencing my previous post, how do you get G1...


    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]

    January 13, 2011 at 3:54 pm

    #1273342

  • RE: csv unpivot WITH identifying column

    The temp table has been used to get a code block for demonstration purposes.

    Assuming you're last statement will end with a semicolon, you could simply use

    WITH CTE AS

    (

    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]

    January 13, 2011 at 3:44 pm

    #1273336

  • RE: Allocate memory to SELECT statement in sql server 2005

    Just as a side note:

    Resource Governor is available only on the Enterprise, Developer, and Evaluation editions of SQL Server (2008 and up).


    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]

    January 13, 2011 at 3:38 pm

    #1273332

  • RE: Need help with query to generate a Matrix

    2. Any number of persons can join the various groups even if they don't currently belong to one

    How would your expected output look like if all the changes for one...


    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]

    January 13, 2011 at 3:21 pm

    #1273319

  • RE: csv unpivot WITH identifying column

    Expanding Waynes code:

    DECLARE @test-2 TABLE (id INT, val VARCHAR(100));

    INSERT INTO @test-2

    SELECT 1,'jack,25,A67,91J,67,99' UNION ALL

    SELECT 2,'jill,5,8,V3' UNION ALL

    SELECT 3,'john,7,D4' UNION ALL

    SELECT 4,'bill,66,84';

    WITH CTE AS

    (

    SELECT *

    FROM

    @test-2

    ...


    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]

    January 13, 2011 at 2:17 pm

    #1273287

  • RE: Need help with query to generate a Matrix

    At the beginning of your post you said "based on a set of data"; but at the end "Any help in terms of what the table structure ... should look...


    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]

    January 13, 2011 at 1:23 pm

    #1273264

  • RE: Are the posted questions getting worse?

    WayneS (1/13/2011)

    LutzM (1/13/2011)

    Any of the Threadizens interested in a performance tuning project in the Los Angeles area? Drop me a PM.

    You're in the LA area? I thought you were in...


    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]

    January 13, 2011 at 12:57 pm

    #1273253

  • RE: Are the posted questions getting worse?

    Any of the Threadizens interested in a performance tuning project in the Los Angeles area? Drop me a PM.


    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]

    January 13, 2011 at 10:09 am

    #1273161

  • RE: Pivot with dynamic number of columns

    Jon.Wales (1/13/2011)

    sorry my English is poor,I'm trying:-D

    Do you have any question? You posted some code. Why?


    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]

    January 13, 2011 at 9:32 am

    #1273134

  • RE: Manipulating data in a table through SSIS

    I guess the issue is related to this thread.

    But it could be something completely different, too...


    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]

    January 12, 2011 at 3:01 pm

    #1272679

  • RE: Pivot with dynamic number of columns

    lduvall (1/12/2011)

    Awesome! Yes, both of these help me tremendously! Thank you so much!

    I've been wanting to learn about the STUFF syntax, too. I'm going to dive into both of...


    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]

    January 12, 2011 at 2:52 pm

    #1272677

  • RE: Pivot with dynamic number of columns

    I'm thrown by the fact that all these scenarios have something to sum and I don't have that.

    Well, you DO have something to aggregate...

    Attached please find tow code snippets:

    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]

    January 12, 2011 at 1:51 pm

    #1272641

  • RE: Pivot with dynamic number of columns

    Instead of using PIVOT I'd rather go with CrossTab and DynamicCrossTab, since the code structure of PIVOT is kinda weird and it doesn't perform better than the CrossTab methods either.

    I'd...


    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]

    January 12, 2011 at 12:26 pm

    #1272569

  • RE: Query Optimization

    It also might help to preaggregate the tables commonly used in both UNION statements (e.g. using a temp table, maybe even a CTE will help) as well as considering UNION...


    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]

    January 12, 2011 at 1:55 am

    #1272226

  • RE: Loading XML Data into SQL Server (SQL Spackle)

    Amy.G (1/11/2011)

    ...

    I'm going to consider this permission to let it go and do other work.

    And thanks for that article. It has proved very helpful.

    Amy

    I'm not sure if a forum post...


    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]

    January 11, 2011 at 4:12 pm

    #1272128

Viewing 15 posts - 2,116 through 2,130 (of 5,502 total)