Forum Replies Created

Viewing 15 posts - 3,871 through 3,885 (of 5,502 total)

  • RE: crosstab SQL Server 2000

    Here's what I came up with.

    The solution will display the first 6 followups. I added a note what to change if more followups are required.

    Once you've studied the concept 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 1, 2010 at 12:08 pm

    #1144353

  • RE: crosstab SQL Server 2000

    orca (4/1/2010)

    I have to admit that I didn't understand much of Lutz solution (but I did copy the suggestion into the Management Studio, and the result was exactly as 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]

    April 1, 2010 at 11:18 am

    #1144291

  • RE: Cross tab and Moving running totals

    Please provide sample data that will describe the scenario you're strugglnig with.

    Based on your vague description it is unclear whether you would have missing rows in #customers for a specific...


    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 1, 2010 at 10:59 am

    #1144263

  • RE: How to tune this query

    Judy-363345 (4/1/2010)

    lmu92 (4/1/2010)

    Did you try the solution I posted earlier?

    SELECT UID, ReferenceNumber, TYPE

    FROM #tbl myTable

    WHERE ReferenceNumber NOT LIKE 'TR%'

    AND EXISTS (SELECT 1 FROM #tbl myTable2 WHERE TYPE = 1...


    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 1, 2010 at 10:51 am

    #1144247

  • RE: How to tune this query

    Did you try the solution I posted earlier?

    SELECT UID, ReferenceNumber, TYPE

    FROM #tbl myTable

    WHERE ReferenceNumber NOT LIKE 'TR%'

    AND EXISTS (SELECT 1 FROM #tbl myTable2 WHERE TYPE = 1 AND myTable.uid...


    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 1, 2010 at 8:14 am

    #1144012

  • RE: Date Conversion

    You could use the following line to find the rows with bad data format:

    SELECT * FROM YourTable WHERE ISDATE(yourColumn) = 0


    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 1, 2010 at 5:29 am

    #1143836

  • RE: DBCC Timewarp

    IIRC DBCC TIMEWARP has 137 parameter plus 256 optional parameter.

    Or will that be in the futures / was it in the past / will it be in the past? :w00t:

    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]

    April 1, 2010 at 5:07 am

    #1143825

  • RE: SQL Query

    Your WHERE condition is transformed into:

    WHERE

    (CardORKey='Key')

    OR

    (

    CardORKey='Both'

    AND

    ( LastName = @LastName

    ...


    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, 2010 at 2:56 pm

    #1143499

  • RE: How to tune this query

    I'm not sure if I'm totally wrong, but isn't that WHERE condition identical to WHERE ReferenceNumber NOT LIKE 'TR%' ?

    Reason:

    With your first subquery you include all UIDs with Type =...


    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, 2010 at 2:41 pm

    #1143482

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/31/2010)

    lmu92 (3/31/2010)

    I think question #6 cannot be answered on this forum at all:

    6 - how operators would move?

    The answer would depend on too many things, e.g.

    How much money 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 31, 2010 at 1:36 pm

    #1143435

  • RE: Are the posted questions getting worse?

    I think question #6 cannot be answered on this forum at all:

    6 - how operators would move?

    The answer would depend on too many things, e.g.

    How much money is offered 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]

    March 31, 2010 at 1:09 pm

    #1143406

  • RE: SQL Bulk Load - Nested Elements

    Did you try to find a solution in BOL (BooksOnLine, the SQL Server help system usually installed together with SQL Server)?

    You might find a solution in section "XML Bulk...


    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, 2010 at 12:49 pm

    #1143371

  • RE: Are the posted questions getting worse?

    But it's a while back since I've last seen a LMGTFY link...

    Seems like we're kinda learning search engine.

    How does a search engine express it's/his/her feelings anyway?


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

    #1143353

  • RE: Cross tab and Moving running totals

    I would do it in three steps:

    step 1: build an intermediate table with preaggregated values

    step 2: do the quirky update

    step 3: display the pivoted data using crossTab

    Something like this (side...


    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, 2010 at 12:16 pm

    #1143336

  • RE: Pivot Question

    Based on your description and ready to use sample data it was really easy to work on and to match your desired result.

    This is one of the very best formats...


    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, 2010 at 3:26 pm

    #1142754

Viewing 15 posts - 3,871 through 3,885 (of 5,502 total)