Forum Replies Created

Viewing 15 posts - 3,121 through 3,135 (of 5,502 total)

  • RE: Newbie sp_xml_preparedocument

    Ram:) (7/16/2010)

    Hi Everyone,

    As per my knowledge, XML is case sensitive.

    The following may result null value..

    Correct me if i am wrong

    ...

    You're right, as already explained a few posts back.


    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]

    July 17, 2010 at 2:06 am

    #1194483

  • RE: arranging columns

    Here's the approach I would use.

    Please note that I had to add an identity column to the source table just like David suggested. In my first reply I assumed 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]

    July 16, 2010 at 3:08 pm

    #1194382

  • RE: Average Inventory (Stock) Age

    If you start using one of the ideas posted in the challenge I referred to and you get stuck, let us know what you're struggling with and I'm sure there...


    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]

    July 16, 2010 at 2:55 pm

    #1194373

  • RE: SQL Subquery Help

    If you would post the execution plans for both queries it would help us a lot to see what changes need to be made to tune the code. 3 seconds...


    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]

    July 16, 2010 at 10:58 am

    #1194231

  • RE: arranging columns

    singhbharat321 (7/16/2010)

    Thanks for the good suggestion!!!!can you write the query for that scenario.i will be very happy if you do for me.Thanks

    Regards

    Bharat

    Please provide table def, sample data and...


    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]

    July 16, 2010 at 10:52 am

    #1194227

  • RE: arranging columns

    Why would you do such formatting server side and not client side? Stuff like this usually should be done by the frontend app.

    But if you're forced to do it, 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]

    July 16, 2010 at 10:13 am

    #1194200

  • RE: SQL Subquery Help

    Hmmm...

    It doesn't really make sense to populate a separate table just to exclude 40 rows...

    I usually use table variables to populate sample data when answering a forum question since 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]

    July 16, 2010 at 9:58 am

    #1194193

  • RE: SQL Subquery Help

    caseyo (7/15/2010)

    @LutzM

    I did not consider to normalize and properly index your tblResults table. I'll have to look up tomorrow on how to do that. I'll also submit 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]

    July 15, 2010 at 4:24 pm

    #1193823

  • RE: Field Array won't Split in expression SSRS 2008

    duplicate / misplaced post.

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

    July 15, 2010 at 4:14 pm

    #1193818

  • RE: Creating Field to group records

    I'd rather use

    SELECT vague_stuff,

    ((ROW_NUMBER() OVER (ORDER BY something)-1) / 50 + 1 ) AS box_nbr

    FROM NamelessFoobar;

    Otherwise your...


    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]

    July 15, 2010 at 4:10 pm

    #1193816

  • RE: Sql Query

    You might want to start with the UNPIVOT statement (see BOL aka BooksOnLine, the SQL Server help sytem for details).

    As a next step you should have a look at 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]

    July 15, 2010 at 4:01 pm

    #1193811

  • RE: Average Inventory (Stock) Age

    It depends on your table design.

    Here's a rather simple example using the sample data you provided:

    DECLARE @tbl TABLE

    (

    article_id INT,

    received INT,

    age INT

    )

    INSERT INTO @tbl

    SELECT 1,30 ,...


    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]

    July 15, 2010 at 3:56 pm

    #1193810

  • RE: Problem with a XML.

    Since you're dealing with a typed xml document, you'd need to declare the namespace(s) defined within that document:

    ;WITH xmlnamespaces(

    DEFAULT 'http://www.portalfiscal.inf.br/nfe'

    )

    SELECT

    R.Node.value('(natOp/text())[1]','varchar(100)') AS natOp,

    R.Node.value('(cNF/text())[1]','varchar(100)') AS cNF

    FROM @XML.nodes('//././ide') R(Node);


    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]

    July 15, 2010 at 3:45 pm

    #1193808

  • RE: SQL Subquery Help

    caseyo (7/15/2010)

    @LutzM Thank you so much. I think this will get me where i need to go.

    This was exactly what I was needing. I modified...


    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]

    July 15, 2010 at 3:40 pm

    #1193806

  • RE: Query that joins a 1-many table returning multiple results

    Based on your sample data I would use the following concept.

    Unfortunately, I was unable to run your original query since there are tables and functions missing. So I had 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]

    July 15, 2010 at 3:03 pm

    #1193791

Viewing 15 posts - 3,121 through 3,135 (of 5,502 total)