Forum Replies Created

Viewing 15 posts - 4,291 through 4,305 (of 5,502 total)

  • RE: cross table/pivot table?

    Did you actually try your sample data within a test database?

    It seems like you didn't...

    Please modify your sample data.

    Side note: You're on the right track in terms of providing 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]

    February 11, 2010 at 5:02 pm

    #1117847

  • RE: Dynamic SQL in creating columns and summary

    mister.magoo (2/11/2010)

    ...

    This kind of dynamic sql works up to a point, but it's not what SQL is good at - let your favoured reporting tool do the formatting...

    Would you mind...


    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]

    February 11, 2010 at 4:58 pm

    #1117844

  • RE: Dynamic SQL in creating columns and summary

    The concept itself is described in the last link in my signature.

    The reason for all the ''' is simple:

    If you want to get the dynamic sql to look like "...CASE...


    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]

    February 11, 2010 at 4:34 pm

    #1117836

  • RE: cross table/pivot table?

    How about changing your data model to be a relational one rather than that ETL stuff?

    It's always a PITA to try to get relational transformation out of an object oriented...


    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]

    February 11, 2010 at 4:22 pm

    #1117831

  • RE: Query Help - difference between last and current year

    Please provide table definition and some sample data to play with as described in the first link in my signature.


    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]

    February 11, 2010 at 12:44 pm

    #1117723

  • RE: Turn rows into columns and calculate increment values

    Roust_m (2/10/2010)

    lmu92 (2/6/2010)

    Would you mind sharing what you've tried so far and where you got stuck?

    Did you have a look at the articles Jack referred to?

    Sorry I've gone missing. ...


    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]

    February 11, 2010 at 12:34 pm

    #1117717

  • RE: Find unused fields in stored procedures

    How would you deal with a scenario where you'd have an (badly written) insert statement like:

    INSERT INTO TargetTable

    SELECT col1, col2, col3

    FROM SourceTable

    You won't find any column of your TargetTable...


    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]

    February 10, 2010 at 1:56 pm

    #1117188

  • RE: SQL Join Help

    Please provide table def and some (fake) sample data (enough to show the effect you're faced with) so we have something to play with.

    Your join syntax seems to be correct...


    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]

    February 10, 2010 at 1:29 pm

    #1117171

  • RE: Single column to multiple columns

    Please search this site for string split functions or have a look at the Tally Table link in my signature which includes an efficient example.


    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]

    February 10, 2010 at 1:11 pm

    #1117158

  • RE: System stored procedure to return empty resultset of the particular user defined stored procedure.

    Your requirement is not clear at all.

    Why would someone run a procedure to get empty result sets?

    What you could do is to add a WHERE 1=2 clause to each 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]

    February 10, 2010 at 12:15 pm

    #1117069

  • RE: DBCC Timewarp

    GSquared (2/9/2010)

    ...

    There isn't yet, but if you plan on storing the future document into a filestream table, and plan a backup for that, you should be able to use this...


    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]

    February 9, 2010 at 12:24 pm

    #1116328

  • RE: DBCC Timewarp

    nigel. (2/9/2010)

    lmu92 (2/8/2010)

    nigel. (2/8/2010)

    My hamster just fell through a distortion in the space-time continuum. Is it possible to get him back using DBCC TIMEWARP. Please help, he was my best...


    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]

    February 9, 2010 at 12:13 pm

    #1116320

  • RE: Help Processing XML docs in a stored procedure

    Glad I could help 🙂


    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]

    February 8, 2010 at 4:17 pm

    #1115858

  • RE: Challenge of allocating collaterals to loans (many to many)

    Please post more detailed information (including execution plan) as described in the second link in my signature.


    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]

    February 8, 2010 at 2:14 pm

    #1115813

  • RE: Data Import with BCP

    Please don't cross post. Same question (to be used for further assitance) asked 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]

    February 8, 2010 at 2:07 pm

    #1115812

Viewing 15 posts - 4,291 through 4,305 (of 5,502 total)