Forum Replies Created

Viewing 15 posts - 5,161 through 5,175 (of 5,502 total)

  • RE: SQL brian teaser...

    Hi Digs,

    a couple questions/comments:

    - Why are you using T-SQL to get the same results as you provided as input data?

    - T-SQL can use the IN clause, but there...


    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]

    July 1, 2009 at 2:39 pm

    #1018705

  • RE: Getting XML in a table format

    Roust_m (6/30/2009)

    This is exactly the article I read before setting the whole thing up. The only problem I have is not being able to retrieve the XML data in...


    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]

    July 1, 2009 at 10:49 am

    #1018583

  • RE: Getting XML in a table format

    Hi Roust_m,

    to begin with the easy stuff: your xml is not well formed. the following closing tags are missing either at the end of your xml or in between:

    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]

    June 30, 2009 at 3:35 pm

    #1018023

  • RE: Trasitive dependencies

    GSquared (6/30/2009)

    If I'd been pressed to pronounce it as a single vocable, I'd have tended towards the English "easel" (as in a tripod used to display something, usually writing 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]

    June 30, 2009 at 2:52 pm

    #1017973

  • RE: Trasitive dependencies

    Florian Reischl (6/30/2009)

    ...I read this "ES(e)L" but I've not been sure if I'm the only guy who felt like a donkey... :hehe:

    Well, since it's an official abbr. do I now...


    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]

    June 30, 2009 at 2:23 pm

    #1017951

  • RE: Trasitive dependencies

    GSquared (6/30/2009)

    ...ESL (English as a Second Language) ...

    Now that's something I'd call a "Linguistic Freudian slip"!

    ESL sounds very close to "Esel", which is German for donkey or jackass. :hehe:

    Coincidence???...


    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]

    June 30, 2009 at 1:59 pm

    #1017935

  • RE: Help Needed ???

    Nice one, Jeff!!

    Sometimes the occurrence of the word "PIVOT" isn't that bad, obviously... - especially when it comes together with an "UN".

    Seems a little easier to deal with than 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]

    June 30, 2009 at 12:56 am

    #1017396

  • RE: Which is Better

    Hi Eswin,

    just a few thoughts while you're working on providing the data:

    - since you're using DATEPART(WEEKDAY ...) function you need to make sure that the setting for @@datefirst is 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]

    June 29, 2009 at 4:21 pm

    #1017291

  • RE: Help Needed ???

    My first response was based on your statement:

    espilman (6/29/2009)

    ... then the case statement will just help the first record. Subsequent records will have to follow the determined order for 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]

    June 29, 2009 at 2:48 pm

    #1017205

  • RE: Help Needed ???

    Ok, I'm done with testing and I think I covered all possible occurrences (except NULL values since there is no business rule on how to handle such values...).

    I used 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]

    June 29, 2009 at 2:22 pm

    #1017182

  • RE: Help Needed ???

    espilman (6/29/2009)

    Unless c1, c2, c3.. are intrinsically meaningless and are just data placeholders, then the case statement will just help the first record. Subsequent records will have to follow 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]

    June 29, 2009 at 2:07 pm

    #1017168

  • RE: Very confusing "Error converting data type numeric to numeric" SQL Error

    How do you access Excel files? Are you using SSIS, linked server, openrowset or any other method?

    From my point of view data format validation should be done before you even...


    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]

    June 29, 2009 at 12:41 pm

    #1017131

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (6/29/2009)

    By the way, I still need somebody to cut my grass!!

    It keeps on raining during the weekend...

    I offer 5 dollars!

    I'll do it, assuming you're covering travel and accommodation...


    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]

    June 29, 2009 at 3:30 am

    #1016674

  • RE: Are the posted questions getting worse?

    Referring to the original purpose of The Thread:

    Any consultant around ready for some charity work?


    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]

    June 29, 2009 at 3:13 am

    #1016667

  • RE: Custom Script Needed

    Hi Rohit,

    Ramji (6/29/2009)

    Kindly let me know if you guys need any more input on this.

    Rohit

    It looks like you've misunderstood the concept of this site... We're not "free-of-charge-online-code-generators"!

    The purpose of 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]

    June 29, 2009 at 2:34 am

    #1016653

Viewing 15 posts - 5,161 through 5,175 (of 5,502 total)