Forum Replies Created

Viewing 15 posts - 1,876 through 1,890 (of 5,502 total)

  • RE: delivery changed date query

    Please provide the sample data your result is based on in a ready to use format.

    Your expected result and the "sample data" provided so far don't seem to match. Please...


    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 21, 2011 at 12:57 pm

    #1289575

  • RE: Extracting XML FROM a table

    You don't need SSIS for it.

    I'd recommend XQuery instead.

    If you could provide a sample and your expected result we could show you an example based on your specific scenario.

    Until then,...


    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 21, 2011 at 8:29 am

    #1289450

  • RE: How to create a primarykey like REC_1,REC-2 and so on?

    Let's begin with the question "Why?":

    What would be the benefit to add a set of character before a number? Please explain the business case in more detail so we can...


    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 21, 2011 at 4:33 am

    #1289353

  • RE: Using INSERT INTO in a Stored procedudre

    Are you sure you'er talking about SQL SERVER 2005 syntax?

    If not, it would be very helpful if you would at least name the software and version you're dealing with...


    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 20, 2011 at 5:04 pm

    #1289274

  • RE: SUM Function Help

    CAST(SUM (chg.TOTAL_QUANTITY / clpt.QUANTITY) AS DECIMAL(8,3)) AS calculated_exponent,


    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 19, 2011 at 2:13 am

    #1289164

  • RE: Using Reference table to look up various codes in a column

    I would shred the comma separate list using a split string function and query the result. Search for DelimitedSplit8K here on SSC for a great example of a split string...


    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 18, 2011 at 6:05 pm

    #1289139

  • RE: Sluggish Perfromance on Server - Task Manager PF Usage too High?

    ...While I do have a specific problem to address...

    What exactly would this specific problem be?

    I cannot find it in your system description...


    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 18, 2011 at 6:02 pm

    #1289138

  • RE: How can I parse this character string into separate records?

    I'd use the following approach:

    Step 1: remove the string before the three equal signs (including two equal signs)

    Step 2: replace all equal signs with commas

    Step 3: call a string...


    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 18, 2011 at 5:58 pm

    #1289137

  • RE: delivery changed date query

    Please provide table def and sample data in a ready to use format as described in the first link in my signature. Also please include your expected output based on...


    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 18, 2011 at 5:52 pm

    #1289136

  • RE: Convert XML to DataTable SQL2008

    Have a look at Jacob Sebastians Blog for several examples.


    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 18, 2011 at 5:49 pm

    #1289135

  • RE: Preventing thiefs from reverse enginnering stored procedures

    We currently have a performance issue with a 3rd party app.

    The SQL code is not encrypted, the rest of the code mainly is stored in dll's.

    I admitt I analyzed 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 18, 2011 at 5:45 pm

    #1289134

  • RE: How to tune/speed up a procedure

    Hi Gregory,

    please provide table def and sample data of all tables involved in a ready to use format. Also please include your expected result based on the sample data you...


    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 18, 2011 at 5:17 pm

    #1289128

  • RE: Are the posted questions getting worse?

    george sibbald (2/18/2011)

    ...

    I was going to stop, but confusing foreigners is too much fun. 🙂

    Statement archived for future reference. 😀

    Remember: all people on this planet are foreigners... 😉


    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 18, 2011 at 5:02 pm

    #1289123

  • RE: Are the posted questions getting worse?

    How about sending the last few hundred (?) posts to DiscoveryChannel? They might be able to make a few stories out of it... 😀

    Very entertaining for an ESL who has...


    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 18, 2011 at 4:58 pm

    #1289122

  • RE: Can I tune this?

    Brandie Tarvin (2/18/2011)

    Thank you all for answering my questions. I appreciate it. I never viewed indexes that way before. I guess I still have a lot to learn.

    And I forgot...


    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 18, 2011 at 6:59 am

    #1288819

Viewing 15 posts - 1,876 through 1,890 (of 5,502 total)