Forum Replies Created

Viewing 15 posts - 4,891 through 4,905 (of 5,502 total)

  • RE: Help with simple conversion of rows into columns

    Global answer: yes.

    The major question would be: Why would you do this?

    A relational database is designed following a simple pattern:

    - data in a row belong together

    - data 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]

    October 6, 2009 at 2:04 pm

    #1062462

  • RE: insert xml into string variable

    Simple answer: yes.

    Example (using AdventureWorks):

    DECLARE @xmlstr nvarchar(1000)

    SET @xmlstr =

    (SELECT top 1 *

    FROM HumanResources.Shift

    FOR xml auto, elements)

    SELECT @xmlstr

    /*Result...


    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]

    October 6, 2009 at 1:18 pm

    #1062440

  • RE: add a field in the 2nd table in the pivot group.

    You might want to have a look at Jeff Moden's article regarding Dynamic Cross Tabs [/url].

    If you need further assistance please provide sample data as described in the link...


    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]

    October 5, 2009 at 3:50 am

    #1061609

  • RE: Find all the vehicleid's of top tree and all the subtrees of each subtree

    Please read and follow the recommendation shown in the link in my signature.

    Your sample data seem to be incomplete:

    - Values for ParentFleetID are missing

    - There is no relation shown between...


    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]

    October 4, 2009 at 2:19 pm

    #1061494

  • RE: excel order form to sql

    duplicate post.

    please continue discussion 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]

    September 30, 2009 at 1:18 pm

    #1060146

  • RE: Return weekly values

    kabaari (9/29/2009)

    Ok, this is close to what I am looking for. I need to return each date once but aggregate my Units Produced.

    SELECT DATEADD(wk, DATEDIFF(wk, 6,...


    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]

    September 29, 2009 at 1:22 pm

    #1059691

  • RE: Formatting XML output to file

    grahamcoombes (9/28/2009)

    Why do I want to read a forum where the "answer" is, you don't need to. Great contribution. Maybe if I can justify my stupid needs to...


    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]

    September 29, 2009 at 7:26 am

    #1059454

  • RE: need help for switching technology

    Triple +1 post.

    Discussion already started here and

    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]

    September 29, 2009 at 7:16 am

    #1059445

  • RE: need help!!

    Triple +1 post.

    Discussion already started here and

    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]

    September 29, 2009 at 7:15 am

    #1059443

  • RE: need help!!!!

    Triple +1 post.

    Discussion already started here and

    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]

    September 29, 2009 at 7:15 am

    #1059442

  • RE: Pivot in SQL 2005

    You might want to have a look at the following article:

    http://www.sqlservercentral.com/articles/Crosstab/65048/


    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]

    September 29, 2009 at 7:10 am

    #1059439

  • RE: Key violation on inserting into an identity field

    Obviously, the data in tableA do have unique values in the primary key field, whereas tableB doesn't.

    Try the following:

    SELECT PrimKey, COUNT(*) FROM TableB

    having COUNT(*) >1

    GROUP BY PrimKey

    This query should result...


    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]

    September 24, 2009 at 4:49 pm

    #1058307

  • RE: Need help - Calculate last 4 month end / Quarter End dates!

    If you look at the upper right hand side of your post you'll find a button named "EDIT ///".

    So, this site has an option to edit your posts.

    However, you cannot...


    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]

    September 24, 2009 at 1:16 pm

    #1058241

  • RE: Calculate last 3 Month End/Quarter End Dates

    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]

    September 24, 2009 at 12:53 pm

    #1058224

  • RE: Need help - Calculate last 4 month end / Quarter End dates!

    Please read and follow the instructions given in the link in my signature.

    This will help you to get answers and help us to understand what you're struggling with.

    The format you...


    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]

    September 24, 2009 at 12:51 pm

    #1058223

Viewing 15 posts - 4,891 through 4,905 (of 5,502 total)