Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 5,502 total)

  • RE: day range in the day range of the other table

    What is your expected output and what have you tried so far?


    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]

    January 17, 2011 at 9:30 am

    #1274296

  • RE: Help Needed To Install Oracle 11g on SUSE11 32 bits Linux

    You might want to post your question in a pure Oracle forum.

    The changes for getting help will be much higher since here you'll mostly find MS SQL folks.


    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]

    January 17, 2011 at 9:28 am

    #1274295

  • RE: Please help with SQL code

    Is there any option to change the values in column COUNTRY_CD, table MG_LOCATION, from FR to FRS rsp. FRN? Then you could simply join on COUNTRY_CD and LOCATION_CD.

    If you can't...


    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]

    January 17, 2011 at 9:22 am

    #1274290

  • RE: SQLServerCentral rankings page ...

    kaspencer (1/17/2011)

    Can I please make two suggestions for improving the information shown on your Rankings Page, where you list the top scorers in the QOD and Postings?

    1. How about indicating...


    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]

    January 17, 2011 at 3:53 am

    #1274178

  • RE: tool to generate code for consuming a web service based on its WSDL?

    Are you sure you're on the right forum?

    This is a SQL forum, not PHP.


    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]

    January 17, 2011 at 2:41 am

    #1274147

  • RE: OR VERSUS UNION all

    Without any further information (e.g. actual execution plan) I'd expect table scans due to the non-SARGable columns in your WHERE clause.

    Furthermore, the part "like @fullname1" might not work as 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]

    January 17, 2011 at 2:39 am

    #1274146

  • RE: Different filters but results returned to the same result set

    You could use a CASE statement to do your conditional COUNT().

    Something like

    SUM(CASE WHEN [Call Status] NOT IN ('Closed','Solved') THEN 1 ELSE 0 END)


    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]

    January 16, 2011 at 5:41 pm

    #1274047

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/16/2011)

    And then you have those individuals that won't even ask their DBAs for help because they don't know them personally and are in a different building.

    Strange he posted...


    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]

    January 16, 2011 at 5:18 pm

    #1274042

  • RE: Multi Level Grouping

    Since I've recently seen a few questions with Tour de France sample data I'm wondering if this is somoe sort of homework or school project. Please clarify.


    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]

    January 16, 2011 at 1:08 pm

    #1274003

  • RE: SQL 2000 - End of Support List

    balasach82 (1/16/2011)

    Thanks Lutz, Gail

    Gail,

    Yes, I am aware of the end of support for SQL 2000. But from the MS site, and from the link Lutz gave, I gather that...


    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]

    January 16, 2011 at 4:41 am

    #1273977

  • RE: SQL 2000 - End of Support List

    http://support.microsoft.com/lifecycle/?p1=2852

    (hint: google search keywords: SQL+2000+lifecycle ;-))


    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]

    January 16, 2011 at 3:18 am

    #1273967

  • RE: CDATA using xml explicit

    If you would provide some ready to use sample data as described in the first link in my signature together with your expected result I'm confident we can help you.

    Based...


    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]

    January 15, 2011 at 3:16 pm

    #1273944

  • RE: Cross join query help

    allmhuran (1/15/2011)

    HAH! Quite true I suppose. Not a problem you're likely ever to run into though, unless for some reason you decide to develop in a different language 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]

    January 15, 2011 at 8:54 am

    #1273912

  • RE: New SSMS addin, complete with demo videos, but need advice

    allmhuran (1/15/2011)

    That's a good idea and one I had only vaguely considered. I'm not sure how I would approach them though. Guess I'll give them a call 🙂

    At least regarding...


    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]

    January 15, 2011 at 8:43 am

    #1273908

  • RE: Cross join query help

    @allmhuran:

    I disagree with your statement "-- alphabetic months are always safe."

    Alphabetic months depend on the language setting. Therefore, I won't consider this format as being safe by any means.

    Simply run...


    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]

    January 15, 2011 at 8:40 am

    #1273905

Viewing 15 posts - 2,086 through 2,100 (of 5,502 total)