Forum Replies Created

Viewing 15 posts - 2,836 through 2,850 (of 5,502 total)

  • RE: Compare Time

    Craig Farrell (9/8/2010)

    LutzM (9/8/2010)

    I would prefer a solution that would be able to benefit from an index on that date column, (snip)

    Lutz, since when does a case statement in a...


    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]

    September 8, 2010 at 2:56 pm

    #1218262

  • RE: GIVING THE SPACE

    Would you mind sharing your solution so others might benefit?


    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]

    September 8, 2010 at 2:44 pm

    #1218257

  • RE: Compare Time

    I would prefer a solution that would be able to benefit from an index on that date column, or I would add shift table that would specify the period it's...


    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]

    September 8, 2010 at 2:13 pm

    #1218236

  • RE: GIVING THE SPACE

    A totally different approach:

    You might want to have a look at one of Jacob Sebastian's TSQL Challenges.

    It might help to look through the various solutions...

    Or, if you already know 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]

    September 8, 2010 at 1:44 pm

    #1218222

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/8/2010)

    I think Lutz has some bad karma going. It seems every weird thread I come across with a difficult OP is one in which Lutz is...


    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]

    September 8, 2010 at 1:38 pm

    #1218217

  • RE: Are the posted questions getting worse?

    Tom.Thomson (9/8/2010)

    WayneS (9/8/2010)

    How about a table where the PK is on a text datatype? (as are most of the other columns also!)

    Now that I've seen that one, and the 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]

    September 8, 2010 at 12:38 pm

    #1218178

  • RE: T-SQL help to convert rows to columns

    Please have a look at the CrossTab article referenced in my signature.

    Give it a try and post back if you get stuck.

    Once you figured how it works you might want...


    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]

    September 8, 2010 at 12:30 pm

    #1218171

  • RE: This is SSC related actually

    Funny...

    Now that you actually have an avatar go back to your question and re-read it. After that have a look at the avatar right next to it. 😉

    I know, 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]

    September 8, 2010 at 12:25 pm

    #1218162

  • RE: SQL Query

    call4ljw (9/8/2010)

    Like this?

    Almost.

    Just try to run that code on a just created (empty) database in your test environment.

    Most probably you'll get the same message like we do when we try...


    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]

    September 8, 2010 at 10:09 am

    #1218076

  • RE: Help for MS Access homework

    GilaMonster (9/8/2010)

    LutzM (9/8/2010)

    I've seen this very same question (including exactly the same query even down to POPDATA.ANCNUMBER=720) at least a dozen times so far.

    Links?

    As requested:

    SSC1,

    SSC2,

    Several links at phpfreaks.com, go4expert.com, 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]

    September 8, 2010 at 9:47 am

    #1218062

  • RE: hi aggregate text values

    What would be your expected output for

    INSERT INTO @Tbl VALUES(1,1,'A')

    INSERT INTO @Tbl VALUES(1,2,'D')

    INSERT INTO @Tbl VALUES(1,3,'X')

    INSERT INTO @Tbl VALUES(1,4,'A')


    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]

    September 8, 2010 at 9:36 am

    #1218053

  • RE: Help for MS Access homework

    Would you mind telling us where you're located at?

    It seems like a phenomenon...

    I've seen this very same question (including exactly the same query even down to POPDATA.ANCNUMBER=720) at least a...


    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]

    September 8, 2010 at 9:28 am

    #1218042

  • RE: Integration of XQuery and T-SQL

    tonyclifton77 (9/8/2010)

    for the expected output I'd be happy with a simple true or false - as in the exist-method.

    What would be your true or false condition?


    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]

    September 8, 2010 at 9:14 am

    #1218024

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/8/2010)

    GilaMonster (9/8/2010)

    Now here's an interesting question...

    Which is going to reach 20 000 posts first, me or the Thread?

    What if your 20000 was also the Thread's 20000? :w00t:

    Sounds like...


    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]

    September 8, 2010 at 8:15 am

    #1217974

  • RE: SQL Query

    WayneS (9/8/2010)

    LutzM (9/8/2010)

    call4ljw (9/8/2010)

    Editted accordingly...

    Not really....

    Sample data in a ready to use format and expected result, please.

    Something like:

    CREATE TABLE Book (BookID int....)

    CREATE TABLE Borrow (BookID int, ...)

    INSERT INTO Book...


    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]

    September 8, 2010 at 8:09 am

    #1217966

Viewing 15 posts - 2,836 through 2,850 (of 5,502 total)