Forum Replies Created

Viewing 15 posts - 2,026 through 2,040 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (1/25/2011)

    ...

    Bing maps are off then. It's just under 7500km from Johannesburg to Algier (http://www.wolframalpha.com/input/?i=what+is+the+distance+from+Johannesburg+to+Algier)

    When using the same tool: London sounds much more reasonable 😉

    Side note: interesting web site...


    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 25, 2011 at 12:59 pm

    #1278132

  • RE: Are the posted questions getting worse?

    GilaMonster (1/25/2011)

    North. About 9000km.

    Not sure, just thinking, maybe, will see, depends....

    Tunis? Algier? Edit: at lest when using Bing maps...


    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 25, 2011 at 12:33 pm

    #1278107

  • RE: Are the posted questions getting worse?

    The current discussion actually provide some answers "someone" might need for a meeting in the near future.

    The question this person has to answer: "What systems are affected and what changes...


    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 25, 2011 at 12:31 pm

    #1278105

  • RE: urgently need advice: mapping XML data to destination columns

    @matt-2:

    You're not talking about the free trial version to design the XSD schema for using it with SSIS, do 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 25, 2011 at 11:20 am

    #1278041

  • RE: Check files If exists or if not exists

    duplicate post.

    Continue discussion 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]

    January 25, 2011 at 1:51 am

    #1277658

  • RE: urgently need advice: mapping XML data to destination columns

    Here's an example:

    DECLARE @xml XML

    DECLARE @xml2 XML

    SELECT @xml='

    <Person>

    <Name ID="1" First="John" Last="Doe">

    <email>1@a.com</email>

    <email>2@b.com</email>

    </Name>

    </Person>'

    SELECT @xml2='

    <Person>

    <Name ID="1" First="John" Last="Doe">

    <email>1@a.com</email>

    </Name>

    <Name ID="1" First="John" Last="Doe">

    <email>2@b.com</email>

    </Name>

    </Person>'

    SELECT @xml,@xml2

    You can shred it so you have one table with on or...


    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 25, 2011 at 1:44 am

    #1277657

  • RE: urgently need advice: mapping XML data to destination columns

    Since there are multiple way to present data in an XML format based on the same relational schema I don't think the tools provided by SSSIS are sufficient enough 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]

    January 25, 2011 at 12:26 am

    #1277634

  • RE: multiple updates

    Your sample data and your expected output don't match.

    Please try to describe more detailed what you're trying to achieve.

    One way of doing it would be to create some sample data...


    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 24, 2011 at 4:04 pm

    #1277513

  • RE: Query Help

    Here's something to get you started.

    Step 1 is to transform the denormalized table back into a normalized structure. Since we already touching each and every row multiple times we can...


    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 24, 2011 at 10:08 am

    #1277320

  • RE: Need help selecting which record to keep for duplicate users

    Please show us what you've tried so far and where you get stuck.

    Your request sounds like we're supposed to code it for you. That's called consulting.


    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 24, 2011 at 3:15 am

    #1277096

  • RE: swap columns and rows using pivot concept in sql server 2005

    The most important question: Are you using SQL Server 2005 (as indicated in the header) or SS2000 (as per the forum you posted in)? Makes a huge difference...

    You might also...


    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 24, 2011 at 3:12 am

    #1277095

  • RE: Query Help

    What exactly is your question?

    A little more information will certainly help... E.g. posting your expected result based on your sample data including some info whether you want to have 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]

    January 24, 2011 at 3:10 am

    #1277092

  • RE: Why it doesnt work??

    igngua (1/21/2011)

    ALZDBA (1/21/2011)

    Just assign an alias to your nested query expression and it will be OK

    select count (*) from

    (select codaux,nomaux from aqua.softland.cwtauxi

    except

    select codaux,nomaux from 0718.softland.cwtauxi) as x

    thanks 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]

    January 21, 2011 at 11:12 am

    #1276707

  • RE: Date range query slow on a date as varchar

    It depends on what you define as the range:

    If you want to keep the column data type but compare dates, you have to use the proper data type leading 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]

    January 21, 2011 at 10:09 am

    #1276666

  • RE: A different Type Of Query

    CELKO (1/21/2011)

    There is a good story about Dr. Codd, ANSI, Primary keys, UNIQUE and NULLs.

    The short version is that the PRIMARY KEY came from the need to have sequential...


    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 21, 2011 at 10:00 am

    #1276660

Viewing 15 posts - 2,026 through 2,040 (of 5,502 total)