Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 5,502 total)

  • RE: Remove duplicate records based on record id, annoying GROUP BY statement

    Here's my attempt. I'm confident there are easier solutions not requiring the multiple sort operations...

    Edit: please explain the difference between this thread and the one Gianluca mentioned earlier. At 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]

    November 25, 2010 at 2:14 pm

    #1255650

  • RE: How to insert all types of special char in database table

    There are several questions:

    1) what do you consider being a "special character"? Do you have just a list of character, a rule on how to define it or a list...


    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]

    November 25, 2010 at 1:29 pm

    #1255645

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/25/2010)

    ...

    Things like that are best reserved for April Fools.

    Jason, are you serious?? Do you really consider Mr. Celko's posts being the source of April Fools???? I urge you 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]

    November 25, 2010 at 1:02 pm

    #1255640

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/24/2010)

    It's a little out of character for me but I know you'll recognize the rhetoric. I just couldn't resist... it was too perfect. Enjoy... 😛

    http://www.sqlservercentral.com/Forums/Topic1025567-392-1.aspx#bm1026289

    I just...


    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]

    November 25, 2010 at 12:17 pm

    #1255632

  • RE: Are the posted questions getting worse?

    To all of you folks in the U.S.:

    May the turkey be tender and juicy and the people you're celebrating with be the ones you love and care about.

    My very special...


    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]

    November 24, 2010 at 4:39 pm

    #1255392

  • RE: Calculate dates an individual lives in apartement each month

    WayneS (11/24/2010)

    stan-617410 (11/24/2010)

    Wayne, Thank you for your persistence and patience.

    No problem. To be fair, Lutz and Ron were pretty instrumental in getting this solved also!

    Is this working right for 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]

    November 24, 2010 at 4:18 pm

    #1255387

  • RE: Dynamic SQL issue

    Jeff Moden (11/24/2010)

    Heh... not to worry, Lutz. You've seen the mess I can make of things if I PBC (Post Before Coffee). 😀

    No, I haven't. I barely can remember...


    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]

    November 24, 2010 at 3:18 pm

    #1255359

  • RE: Calculate dates an individual lives in apartement each month

    WayneS (11/24/2010)

    :blush: (not again!!!) This should do it this time!

    ...

    @Lutz: thanks, but it's reporting the days in the following months as zero, not the proper days. It comes down 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]

    November 24, 2010 at 2:42 pm

    #1255348

  • RE: Calculate dates an individual lives in apartement each month

    change the appropriate section in cte2 to

    ,StayForMonth = CASE WHEN Move_In_Date > StartOfMonth AND Move_out_Date <= EndOfMonth

    ...


    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]

    November 24, 2010 at 2:21 pm

    #1255334

  • RE: Are the posted questions getting worse?

    I sometimes feel like reporting his posts as "plain advert covered by some rather unhelpful or unrelated advice"...

    But I think all it would generate would be some additional work for...


    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]

    November 24, 2010 at 2:09 pm

    #1255327

  • RE: Dynamic SQL issue

    Jeff Moden (11/23/2010)

    LutzM (11/23/2010)

    What's the specific reason for you not to use global temp tables (##table)

    Concurrency and logical separation of data between concurrent runs because all sprocs that use it...


    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]

    November 24, 2010 at 12:57 pm

    #1255293

  • RE: Opening a sql database using access

    WILLIAM MITCHELL (11/24/2010)

    Ozzy,

    You need to create & set three startup properties for the Access database:

    StartupShowDBWindow = False

    AllowSpecialKeys = False

    AllowBypassKey = False

    this will prevent the user from accessing the database window...


    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]

    November 24, 2010 at 12:47 pm

    #1255286

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/24/2010)

    ...

    Alvin Ramard (11/23/2010)

    Depends on what I'm hunting. 😎

    ...

    Wayne, I'm in Memphis. I was waiting for that M R Ducks one. 😀

    Permanently or just getting something...


    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]

    November 24, 2010 at 7:44 am

    #1255103

  • RE: Dynamic SQL issue

    The task seems to be straightforward.

    What would you need the dynamic sql for?

    Couldn't you just pass the VARCHAR(MAX) value, the @where variable and the call of fnDelimitedSplit to the dynamic...


    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]

    November 23, 2010 at 3:41 pm

    #1254798

  • RE: Update using case statement

    Is there any specific reason for using the least preferred method?


    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]

    November 23, 2010 at 3:33 pm

    #1254792

Viewing 15 posts - 2,521 through 2,535 (of 5,502 total)