Forum Replies Created

Viewing 15 posts - 4,276 through 4,290 (of 5,502 total)

  • RE: Insert value using XML

    Where exactly did you get stuck?

    Do you have difficulties to shred the xml data?

    If so, the following might help you.

    If you want us to do the complete work for 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]

    February 14, 2010 at 8:54 am

    #1118578

  • RE: convert nvarchar to int

    What is the result of the following query?

    SELECT * FROM myTable WHERE myField like '%[^0-9]%'

    It will return all rows that might cause problems when converting to INT.

    Maybe this will help...


    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]

    February 14, 2010 at 7:37 am

    #1118570

  • RE: Caching a table

    AFAIK there's no way to force a table to be hold in cache when using SS2K5.

    SQL Server manages the cache internally and will hold data in cache if possible 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]

    February 14, 2010 at 7:23 am

    #1118566

  • RE: Problem in calculating missing periods

    Looks like I'm getting too addicted to CTEs... 😛


    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]

    February 14, 2010 at 2:39 am

    #1118548

  • RE: Problem in calculating missing periods

    Jeff Moden (2/13/2010)

    Lutz,

    I'm possibly missing the bubble here... why wouldn't the following two entries be added together for a single "period"?

    SELECT '2','2','20090205','200','80' UNION ALL

    SELECT '2','2','20090207','200','80'

    I'm not the OP so I...


    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]

    February 13, 2010 at 5:04 pm

    #1118503

  • RE: Where are you?

    Jeff Moden (2/13/2010)

    ...

    A bit anti-American and a bit over the top in any case for any international forum such as this.

    Under the "given circumstances" (XXI. Olympic Winter Games 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]

    February 13, 2010 at 3:36 pm

    #1118497

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/13/2010)

    ...Doc only gave me the 5 year warrenty...

    You actually have doctors over there that'll give you any kind of warranty? Wow!


    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]

    February 13, 2010 at 11:48 am

    #1118473

  • RE: Problem in calculating missing periods

    ChrisM@home (2/13/2010)

    lmu92 (2/13/2010)

    And here's what I came up with (@ Chris: yes, a bunch of CTE's again :-D)

    Who needs CTE's? 😛

    Maybe someone who looks at execution plans and wonder why...


    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]

    February 13, 2010 at 11:41 am

    #1118471

  • RE: Problem in calculating missing periods

    It's charity Saturday so I took the time to clean up the sample data you provided...

    Additionally to the errors Chris already mentioned: there is no '4/31/09'. At least not 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]

    February 13, 2010 at 3:44 am

    #1118407

  • RE: Use dynamic Pivot table as part of another query

    ChrisM@home (2/12/2010)

    ...

    I think it works with

    INSERT INTO #Temptable EXECUTE (@Query)

    but of course you have to create #Temptable beforehand.

    @Lutz - that was too funny, man! 😀 Go home, have beer!

    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]

    February 12, 2010 at 3:38 pm

    #1118338

  • RE: Are the posted questions getting worse?

    Es scheint, als ob nunmehr die jeweilige Muttersprache für Beiträge in "The Thread" genutzt wird. Ich bin mir nicht sicher, ob dadurch die Kommunikation vereinfacht wird... 😉

    Translation for those who...


    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]

    February 12, 2010 at 2:28 pm

    #1118310

  • RE: ASC and DESC in dynamic ORDER BY clause

    I couldn't find an elegant way but here's what might work if you have to have a paramterized option for ASC/DESC:

    DECLARE @SortOrder INT

    SET @SortOrder=2

    DECLARE @SortOrder2 INT

    SET @SortOrder2=2

    ;WITH cte AS

    (

    SELECT...


    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]

    February 12, 2010 at 2:18 pm

    #1118306

  • RE: Use dynamic Pivot table as part of another query

    Arrgghhh!

    My fault!

    I totally forgot/overlooked/ignored that the EXEC() command will run under a separate session.. I'M SORRY!!!

    One option would be to use a permanent table instead of a temp table. But...


    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]

    February 12, 2010 at 1:41 pm

    #1118288

  • RE: SQLXMLBulkLoad: Import nested XML fails

    As far as I can see the problem is that your Data1 element is part of ReferenceDatas/ReferenceData not but you declare it as being part of the Reference node.

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

    February 12, 2010 at 1:02 pm

    #1118260

  • RE: Use dynamic Pivot table as part of another query

    You could change

    select @sql=

    '

    select * from

    to

    select @sql=

    '

    select * INTO #TargetTable

    from

    But make sure to include the existance check including a conditional drop table ...


    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]

    February 12, 2010 at 12:51 pm

    #1118245

Viewing 15 posts - 4,276 through 4,290 (of 5,502 total)