Forum Replies Created

Viewing 15 posts - 5,446 through 5,460 (of 5,502 total)

  • RE: Group By or maybe not?

    Hi,

    is it possible that you're using SQL Server 2008?

    The statement

    DECLARE @DateFrom as date = '20090101';

    is no SS2K syntax, but that's the forum you posted in.

    Please clarify, since this will...


    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]

    March 31, 2009 at 8:28 am

    #969163

  • RE: Group By or maybe not?

    Unfortunately, you decided not to follow the recommendation from my previous post.

    Instead of adding more information you posted less.:crying:

    Since I can't really find any link between your first and your...


    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]

    March 30, 2009 at 5:37 pm

    #968802

  • RE: Group By or maybe not?

    Sure.

    But please provide some more information to figure out what you're trying to do... 😉

    The previous one was more guessing than knowing what you're looking for...

    Also, it would help if...


    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]

    March 30, 2009 at 5:10 pm

    #968791

  • RE: Group By or maybe not?

    Hi,

    would this be the answer to your question?

    select t1.id, count(t1.id) from @Table1 t1 inner join @Table2 t2

    on t2.id like (t1.id + '%')

    group by t1.id

    order by t1.id

    Or maybe

    select t1.id, sum(t2.Value)...


    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]

    March 30, 2009 at 4:30 pm

    #968772

  • RE: insert XML data to SQL server two tables

    Hi yaman bas,

    first of all I need to apologize for recommending a solution that doesn't work on your platform...

    I didn't pay enough attention to what forum you posted in...:blush:

    But, [thank...


    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]

    March 30, 2009 at 3:17 pm

    #968722

  • RE: insert XML data to SQL server two tables

    proposal deleted due to nonworking solution under the given environment (XQuery together XML data type proposed, which doesn't work on SS2K).

    Revised proposal see post

    http://www.sqlservercentral.com/Forums/FindPost686570.aspx


    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]

    March 30, 2009 at 9:30 am

    #968457

  • RE: Result are not comming as expected

    What is your expected result?

    Based on the test data you provided the result is 60 for p1 and 50 for p2.

    Mathematically correct.

    The way your where condition is written you are...


    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]

    March 30, 2009 at 5:30 am

    #968226

  • RE: help with a script causing locking and blocking

    Hi ravinegi,

    I think you should post the city/state/country your company is located.

    Therewith you'd probably get contacted from one of the local consultants that follow this site or even participate.

    The way...


    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]

    March 29, 2009 at 11:19 am

    #968037

  • RE: Getting XML formatted results From SQL 2000

    Would it help just to wrap the root elements around your select stement?

    select '{root}' + (SELECT name, description from Orders FOR XML AUTO, ELEMENTS) + '{/root}'

    Note: The xml doesn't show...


    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]

    March 26, 2009 at 3:52 am

    #966498

  • RE: insert XML data in to sqlserver 2005 table in their respective columns....

    Hello Pranav,

    With the limited information you provided all I can get you is a limited answer:

    Please check the XML Forum of this site http://www.sqlservercentral.com/Forums/Forum21-1.aspx

    There should be at least one answer...


    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]

    March 26, 2009 at 3:32 am

    #966489

  • RE: Help needed...Manual sorting

    SET sarcasm ON

    For answers please see http://www.cheatSQL101.org.

    SET sarcasm OFF

    I'm sorry, but the old fashioned way of dealing with homework is studying.

    The purpose is that you learn how the concept is...


    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]

    March 25, 2009 at 1:13 am

    #965822

  • RE: Which country is best for Outsourcing?

    Hey, you know, I'm just thinking about the following scenario:

    If each and every company is outsourcing, then everybody will (still) have enough to do:

    Example:

    Starting outsourcing from the U.S.

    Since you're running...


    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]

    March 24, 2009 at 5:45 pm

    #965736

  • RE: Finding Missing Date

    karthikeyan (3/23/2009)

    2009-01-07 is coming between the date range. so i have to insert it into the table. suppose 2009-01-09 is missing then we no need to insert it.

    if the last...


    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]

    March 24, 2009 at 5:08 pm

    #965730

  • RE: Which country is best for Outsourcing?

    umar iqbal (3/24/2009)

    But if you want cheap solution and ... want to save money then it would be INDIA the great. oooooo

    We have a saying over here in Germany...


    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]

    March 24, 2009 at 2:03 pm

    #965579

  • RE: Which country is best for Outsourcing?

    umar iqbal (3/24/2009)

    Japaneese, Germans, French never outsource . How they surviving?

    That's definitely not true! I know a few companies that are at least trying to outsource.

    Like I mentioned...


    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]

    March 24, 2009 at 12:32 pm

    #965493

Viewing 15 posts - 5,446 through 5,460 (of 5,502 total)