Forum Replies Created

Viewing 15 posts - 1,861 through 1,875 (of 5,502 total)

  • RE: Return records at least 10 minutes apart from last valid record without CURSOR

    This thread has a similar requirement.

    I posted a "quirky update" over there you might be able to modify.

    Edit: Craig, you beat me to it. Again.


    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 22, 2011 at 3:36 pm

    #1290174

  • RE: How to sort using DateTime

    gemni7 (2/22/2011)

    u sure its running on your machine? giving errors here....

    the article you mentioned is a long but very informative, i really need to understand this... thanks for mentioning 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 22, 2011 at 3:27 pm

    #1290169

  • RE: Working with large de-normalized dataset

    As an alternative to the PIVOT syntax you could have a look at the CrossTab and DynamicCrossTab article referenced in my signature.

    It's not as easy as using Excel, but Excel...


    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 22, 2011 at 2:40 pm

    #1290137

  • RE: Help with getting a value in correct order

    Something like this?

    (Please note the rows are not ordered as your expected output since your original query doesn't include an ORDER BY)

    SELECT

    fee_portion, fee_percent, settle_date, fee_atty, manager, primary_attorney,

    [Settle Amount]...


    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 22, 2011 at 2:30 pm

    #1290129

  • RE: How to sort using DateTime

    All I could come up with is using the "Quirky Update" method:

    You'd need to add another column to your table or copy the data into a temp table if you're...


    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 22, 2011 at 2:15 pm

    #1290120

  • RE: Are the posted questions getting worse?

    Jack Corbett (2/22/2011)

    ...

    I have not. My opinion is that if you need to protect the code, and if it is really proprietary, it belongs in the business layer, not...


    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 22, 2011 at 1:06 pm

    #1290064

  • RE: variable column count txt files to sql server table

    I would use SSIS to store the CSV list into a staging table with a single column.

    Then I would call a sproc with a fast split string function (e.g. DelimitedSplit8K)...


    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 22, 2011 at 1:01 pm

    #1290058

  • RE: Group by and Concatenate just one field?

    Search this site for "concatenate FOR XML PATH".


    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 22, 2011 at 11:59 am

    #1290022

  • RE: How to sort using DateTime

    Based on your sample data there are no consecutive rows for the sensorID in question with the required 5min gap.

    I think it would help a lot if you could post...


    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 22, 2011 at 11:52 am

    #1290013

  • RE: Are the posted questions getting worse?

    Jeff Moden (2/21/2011)

    ...

    I dun no... DE-troit boy goin ta ohia mur dan wonce in da sames yer mite git da kin folk resluss en tha lak.

    Here's my ESL...


    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 22, 2011 at 11:39 am

    #1290005

  • RE: Preventing thiefs from reverse enginnering stored procedures

    sdffdfad faadffad (2/22/2011)

    And what would you advise to us? To serve to all the competitors de-facto source code on golden plate and share with them results of years of research...


    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 22, 2011 at 10:48 am

    #1289967

  • RE: delivery changed date query

    tt-615680 (2/22/2011)

    LutzM (2/21/2011)

    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...


    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 22, 2011 at 10:31 am

    #1289956

  • RE: Extracting XML FROM a table

    oconnor_dp (2/22/2011)

    Try this example:

    http://social.msdn.microsoft.com/Forums/en/sqlxml/thread/69b87bea-a943-4e53-8bfc-6a5e9213c2f4

    Please mark as answer if you find it helpful.

    Is there any specific reason for posting a solution on another website for a question 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 22, 2011 at 10:26 am

    #1289953

  • RE: Pivot Query with 2 aggregated functions combined?

    Darundo (2/21/2011)

    ...

    Any suggestion? Or additional information you need please let me know

    Please provide table definition, sample data and expected results based on those sample.


    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 2:15 pm

    #1289612

  • RE: How to tune text queries

    AJ-636201 (2/21/2011)

    Hey Thanks Creig,

    So such a query can not be improved, there will always be an index scan.

    So i think i got my answer:crying:

    Thanks

    There is (at least) one option left:

    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 21, 2011 at 1:02 pm

    #1289580

Viewing 15 posts - 1,861 through 1,875 (of 5,502 total)