Forum Replies Created

Viewing 15 posts - 2,911 through 2,925 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (8/31/2010)

    Various curries, beer and red wine on this side. And no, I'm not a DBA either, so my choice of energy providing food/drink sources may not...


    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]

    August 31, 2010 at 1:08 pm

    #1214573

  • RE: Dynamic Columns - Cash Flow problem

    Please have a look at the CrossTab article referenced in my signature to get your data pivoted.

    Once you know how the concept works move on to the DynamicCrossTab article 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]

    August 31, 2010 at 10:43 am

    #1214475

  • RE: Crosstab for Generic Data

    Please have a look at the DynamicCrossTab article referenced in my signature. I guess this approach will do the job.

    If you need further assistance please provide table def, sample 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]

    August 31, 2010 at 6:49 am

    #1214221

  • RE: Service Broker - Recommended Reading?

    I refer to rusanu's web site[/url] once in a while.

    It might help you as well, even though most of the stuff he wrote about is related to SS2K5.

    I can also...


    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]

    August 30, 2010 at 9:47 am

    #1213807

  • RE: help with query...

    Please read and follow the advice given in the first link in my signature and provide ready to use sample data. Furthermore, please include your expected result based on 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]

    August 30, 2010 at 3:54 am

    #1213647

  • RE: help on xml schema

    You need to include the namespace declaration in your SELECt statement.

    Assuminig you're using SS2K5 or SS2K8, here's the XQuery snippet I would use:

    declare @xml xml

    set @xml='<HousingLoan xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

    <MemberData>

    <Name>alan</Name>

    </MemberData>

    <FinanciarData>

    <Source>Bank</Source>

    </FinanciarData>

    </HousingLoan>'

    ;

    WITH XMLNAMESPACES

    ('http://www.w3.org/2001/XMLSchema-instance' as...


    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]

    August 30, 2010 at 3:48 am

    #1213642

  • RE: Are the posted questions getting worse?

    RBarryYoung (8/28/2010)

    ...

    *sigh* Long story, ... between work problems and medical problems I literally have no time for anything else. Don't get me wrong, neither is serious, but both...


    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]

    August 28, 2010 at 8:24 am

    #1213421

  • RE: Are the posted questions getting worse?

    RBarryYoung (8/28/2010)

    CirquedeSQLeil (8/27/2010)

    Trey Staker (8/27/2010)

    The executive assistant to our CIO ...

    Ha - I first read that as "Execution Assistant..."

    That would have been funny.:-D Would go really well with 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]

    August 28, 2010 at 7:55 am

    #1213419

  • RE: Pivot w/o aggregation...query not working

    Your pvt subqry does not contain a column named [Personnel_id]. Therefore, your ORDER BY fails.

    I think that's not the only flaw in your query...

    But without any table def, sample 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]

    August 28, 2010 at 6:06 am

    #1213402

  • RE: Can a SP invoke a thread to call another function

    I think it will be better to redesign the whole process. Modify the analysis procedure to process all products at once instead of calling it for each product separately. Or,...


    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]

    August 28, 2010 at 5:56 am

    #1213401

  • RE: Error converting data type varchar to float.

    How about providing table def, ready to use sample data and expected result? It would help a lot more than asking one question at a time...


    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]

    August 27, 2010 at 2:49 pm

    #1213271

  • RE: Error converting data type varchar to float.

    How about

    CAST (Replace(Performance,',','.') AS DECIMAL(7,3))

    As a side note: Why did you try to cast it to float in between? Shouldn't be needed.


    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]

    August 27, 2010 at 1:47 pm

    #1213233

  • RE: xml datatype/return as a result set

    I don't know why you'd want to return the content of the ROOT node as well, but...

    Here's my approach:

    DECLARE @tbl TABLE (TRNKEY_XML XML)

    INSERT INTO @tbl SELECT

    '<ROOT>

    <PROGRAM>ACSYNC</PROGRAM>

    <Old_SSN>123456789</Old_SSN>

    <New_SSN>987654321</New_SSN>

    </ROOT>'

    SELECT

    TRNKEY_XML,

    T.c.value('PROGRAM[1]','VARCHAR(10)') AS PROGRAM,

    T.c.value('Old_SSN[1]','VARCHAR(10)')...


    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]

    August 27, 2010 at 1:31 pm

    #1213214

  • RE: Updating XML stored in a column via update text function????

    No big deal. I just wanted to stop it before becoming a habit... 😉

    Did you see my subject-related reply on one of your threads?


    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]

    August 27, 2010 at 12:49 pm

    #1213193

  • RE: Select Columns based on input

    Another option would be to normalize your data either by changing the design or using UNPIVOT. The required data could easily be selected from the resulting table (or cte or...


    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]

    August 27, 2010 at 11:19 am

    #1213123

Viewing 15 posts - 2,911 through 2,925 (of 5,502 total)