Forum Replies Created

Viewing 15 posts - 3,721 through 3,735 (of 5,502 total)

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/20/2010)

    Quick question, can you reuse CTE's in 2 separate statements inside a procedure?

    Nope. You'd have to use an intermediate table to hold the results (either SELECT INTO or INSERT...


    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]

    April 20, 2010 at 1:59 pm

    #1154914

  • RE: Manipulation on Excel generated XML file in sql server 2005

    Yes, you'd need to declare namespaces.

    There are several ways to shed some light on it:

    1) have a look at BOL (BooksOnLine), section WITH XMLNAMESPACES.

    2) search this site for "XML Workshop...


    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]

    April 20, 2010 at 12:32 pm

    #1154861

  • RE: How to limit number of query() result?

    Would you mind telling us the business reason behind it?

    Usually, the order of similar elements/sub-nodes within a node level is irrelevant.

    What is the reason you don't want to use T-SQL?


    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]

    April 20, 2010 at 12:27 pm

    #1154857

  • RE: T-SQL t export table to Access

    You could add your ACCESS db as a linked server and use it like a SQL Server database.

    See BOL, section "linked servers [SQL Server], Access databases" (BooksOnLine, the SQL Server...


    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]

    April 20, 2010 at 12:12 pm

    #1154845

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/20/2010)

    ...

    If I read this right, we can go ahead and get rid of both the temp tables that we are using and just use the PermitsInserted table to track...


    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]

    April 20, 2010 at 10:28 am

    #1154758

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/20/2010)

    Ok, back to the fun...

    How does this code block work (the MAX part) when it is going to return a non-integer value for the error mesage?

    MAX(CASE WHEN Recordindicator =1...


    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]

    April 20, 2010 at 10:23 am

    #1154752

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/20/2010)

    And Congrats to your Bachelor degree, too!!!

    BTW Lutz, getting married, not graduating...

    Ooops, sorry for the misunderstanding... :blush:


    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]

    April 20, 2010 at 10:17 am

    #1154746

  • RE: Understanding and Using APPLY (Part 2)

    Great article series, Paul!

    It was a pleasure being selected to get a preview and to give some thoughts/comments.

    Let's see how long it takes until I have referenced those two articles...


    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]

    April 19, 2010 at 3:49 pm

    #1154186

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (4/19/2010)

    I added some levels to the count. Didn't announce it since they really only applied to me for now. Jeff/Lynn/Gal soon.

    "Soon" has been recently?

    See here 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]

    April 19, 2010 at 3:19 pm

    #1154172

  • RE: Previewing data in cross tab format

    Please have a look at the CrossTab article referenced in my signature. Once you know how that works you probably should go to the "next level", DynamicCrossTab, referenced 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]

    April 19, 2010 at 2:46 pm

    #1154157

  • RE: Are the posted questions getting worse?

    Edit: post removed.

    Content: Side effect of the "wrong quote bug", part 2.

    Was funny just for the moment...


    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]

    April 19, 2010 at 2:29 pm

    #1154151

  • RE: How to add add columns in a SP and reference them in the same SP?

    May I ask for the business reason for that requirement?

    It sounds like a denormalized table (e.g. a monthly summary table with one column per month...)...


    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]

    April 19, 2010 at 2:21 pm

    #1154148

  • RE: Are the posted questions getting worse?

    Edit: post removed.

    Content: Side effect of the "wrong quote bug", part 1.

    Was funny just for the moment...


    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]

    April 19, 2010 at 2:15 pm

    #1154143

  • RE: Are the posted questions getting worse?

    @all

    Did you notice that "someone" added some new level names?

    I noticed SSCoach (Gail, >15K points) and SSC-Insane (Jeff & Steve, >20K points).

    @steve-2

    Did I miss the announcement? Are there other new...


    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]

    April 19, 2010 at 2:06 pm

    #1154137

  • RE: Are the posted questions getting worse?

    Hi,

    anybody of you folks influenced by the volcano eruption on Iceland?

    We're getting low on components supplied by a U.S. company because there are no flights to Europe since last...


    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]

    April 19, 2010 at 1:48 pm

    #1154129

Viewing 15 posts - 3,721 through 3,735 (of 5,502 total)