Forum Replies Created

Viewing 15 posts - 5,056 through 5,070 (of 5,502 total)

  • RE: Display Numeric Data in Scientific Notation

    triple post.

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

    August 17, 2009 at 3:12 pm

    #1040529

  • RE: Display Numeric Data in Scientific Notation

    triple post.

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

    August 17, 2009 at 3:11 pm

    #1040528

  • RE: Aging Report

    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]

    August 17, 2009 at 3:08 pm

    #1040525

  • RE: Large XML values slow to process

    Now it gets confusing... :ermm:

    Your sample data do contain the tag [caseID], which can be used to differentiate between each [orderdocumentrequest].

    If that's not the case, you still could use all...


    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 17, 2009 at 2:51 pm

    #1040510

  • RE: Large XML values slow to process

    Try the following code. It's based on your sample with two minor changes:

    First, I made it case sensitive to match your sample data and secondly, I added the caseID, assuming...


    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 17, 2009 at 2:14 pm

    #1040485

  • RE: Table variables vs. temp tables, and should I use subqueries to minimize # of updates in these?

    Just a few thoughts on the issue:

    1) Like Barry advised, you should think about the process and the purpose of the data again. What data are part of the scan...


    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 17, 2009 at 1:38 pm

    #1040449

  • RE: Large XML values slow to process

    The first question that comes into my mind when reading the requirement:

    What is the business requirement of adding a NEWID to an xml variable using SQL server and leave it...


    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 17, 2009 at 12:54 pm

    #1040425

  • RE: How to Flatten Table Resultset

    Please search for "PIVOT" or "CROSS TAB" on this site.

    You'll find a number of posts where at least one should answer your question.

    You could also go directly to one 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]

    August 17, 2009 at 12:32 pm

    #1040413

  • RE: Obtaining history totals on a monthly basis with only one table read?

    A few more things to add:

    #1) I forgot to thank you for the way you've provided sample data and that you took the time to dive into the solution I...


    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 17, 2009 at 10:04 am

    #1040313

  • RE: Obtaining history totals on a monthly basis with only one table read?

    kramaswamy (8/17/2009)

    So, let me see if I understand this right.

    What you're essentially doing is, getting a total of the subscribers on a monthly basis, and then, using the results stored...


    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 17, 2009 at 9:27 am

    #1040273

  • RE: Obtaining history totals on a monthly basis with only one table read?

    I assume you have something like a calendar table...

    If not, I've included a calendar (CTE_calendar) in the code below.

    Also, please note that I've used a temp table with a PK...


    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 17, 2009 at 7:22 am

    #1040162

  • RE: Aging Query

    Please take the time to help us help you.

    In order to get a solution to the problem you described some of us like to have ready to use data (including...


    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 17, 2009 at 5:46 am

    #1040105

  • RE: to show row wise data into column wise

    Basically, there are two ways for this common requirement:

    one is the PIVOT function (see BOL = BooksOnLine, the SQL help system, for details) and the other option uses 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 17, 2009 at 2:01 am

    #1040047

  • RE: xml retirve

    Hi,

    you could use something along those lines:

    SELECT DISTINCT

    c.value('@Id[1]','varchar(30)') AS FeatureID,

    c.value('ReadPermission[1]','varchar(30)') AS ReadPerm,

    c.value('WritePermission[1]','varchar(30)') AS WritePerm

    FROM @FeatureList.nodes('Features/Feature') AS T(c)

    /* result set:

    FeatureIDReadPermWritePerm

    6a698c85-4e95-4827-87b4-6eb4d7"true""false"

    */


    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 14, 2009 at 3:47 pm

    #1039740

  • RE: select

    In that case I'd assume you're doing some kind of grouping with the data.

    I'd recommend to do the aggregation on SQL Server side and select the aggregated data into SSRS....


    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 13, 2009 at 1:32 pm

    #1038965

Viewing 15 posts - 5,056 through 5,070 (of 5,502 total)