Forum Replies Created

Viewing 15 posts - 3,811 through 3,825 (of 5,502 total)

  • RE: A questions about summarisation

    Please provide sample data and expected output in a ready to use format as described in the first link in my signature.

    You have visited this side often 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]

    April 11, 2010 at 6:50 pm

    #1149791

  • RE: Group values based on two columns of data

    When thinking about the data you provided it might be easier to start from scratch.

    It might be a lot easier to deal with the xml data instead of the intermediate...


    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]

    April 11, 2010 at 2:21 pm

    #1149769

  • RE: Group values based on two columns of data

    May I point you to the first link in my signature again?

    You can also have a look at my first reply to see how I created the test table 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]

    April 11, 2010 at 2:12 pm

    #1149765

  • RE: Which Table has to be loaded first ?????

    I searched for scripts on this site using the keywords "script table relationship" and found the following link that might get you started:

    http://www.sqlservercentral.com/scripts/scripting/69282/


    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]

    April 11, 2010 at 11:46 am

    #1149738

  • RE: Remove orphan PK

    You need to figure out what table this primary key belongs to.

    Run

    SELECT * FROM sys.objects where object_id=149575571

    to check what table that PK belongs to. It does not have 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]

    April 11, 2010 at 11:40 am

    #1149737

  • RE: Group values based on two columns of data

    Unfortunately, your description is not very clear nor do we have any (runable) code that would support your question nor any expected result based on your sample data...

    Therefore, I had...


    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]

    April 11, 2010 at 11:33 am

    #1149733

  • RE: data manipulation by row

    It doesn't sound like a processing issue but rather an issue of finding the proper ORDER BY condition.

    In order to do that it's required to define a sorting criteria. 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]

    April 10, 2010 at 3:26 am

    #1149540

  • RE: Purpose of few SSIS Packages

    CirquedeSQLeil (4/9/2010)

    ...

    And the State Security Annihilation Service doesn't bother asking questions - they just act.

    That's where the QA (question asking tool) comes into play...


    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]

    April 9, 2010 at 5:23 pm

    #1149432

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/9/2010)

    Is today Friday?

    It depends.

    Over here in Germany is Saturday since over an hour. 😀

    Gooooood morning SSCeeeeeaaaaahhh!


    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]

    April 9, 2010 at 5:12 pm

    #1149426

  • RE: Purpose of few SSIS Packages

    Tom.Thomson (4/8/2010)

    SSIS is used very extensively by the state security services of several countries to generate evidence for important show trials. This usage occurs mainly in Eastern Asia. ...


    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]

    April 9, 2010 at 5:01 pm

    #1149424

  • RE: Calling a website...

    If the communication between website and SQL Server is done through procedures only (which I would assume/recommend/expect) then you could add a begin and end timestamp within your procedures 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]

    April 9, 2010 at 4:15 pm

    #1149410

  • RE: How to build 7 day slots based on start and end dates?

    Please explain a little more detailed what your looking for. The best way would be to give us some sample data and expected result. Furthermore, you need to define 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]

    April 9, 2010 at 2:58 pm

    #1149387

  • RE: Overlapping Date Ranges with Gaps Possible

    @Ron:

    Unfortunately, your solution does lead to pay twice for one hour.

    For example emp_id 222:

    The hour between 17:00 18:00 is included twice in the sample data (for shift A and 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]

    April 9, 2010 at 2:39 pm

    #1149373

  • RE: Overlapping Date Ranges with Gaps Possible

    Here's another version.

    Side note: instead of expanding it to 24hrs per day I just used the hours between noon and 10pm. If you need all 24hrs, you'd need to change...


    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]

    April 9, 2010 at 2:13 pm

    #1149359

  • RE: Overlapping Date Ranges with Gaps Possible

    Your reply doesn't really answer the question on how to actually calculate the working hours.

    Your sample data do make room for some interpretation... Also, your desired result is an integer...


    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]

    April 9, 2010 at 1:08 pm

    #1149334

Viewing 15 posts - 3,811 through 3,825 (of 5,502 total)