Forum Replies Created

Viewing 15 posts - 3,691 through 3,705 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    This OP "really appreciates" 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]

    April 23, 2010 at 12:49 pm

    #1157095

  • RE: how to show deleted rows

    ramirez.sebastian (4/23/2010)

    thank you all,

    you could be more helpful

    appreciate it,

    What help did you expect? You posted a vague question. So you got vague answers. And you haven't even answered my...


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

    #1157091

  • RE: how to show deleted rows

    Koncentrix (4/23/2010)

    Another thing is ...

    DELETE #temp

    OUTPUT DELETED.*;

    in the following DELETE statement returns all columns deleted from the #temp table

    Please note that this is an 2000...


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

    #1157076

  • RE: how to show deleted rows

    Just asking for clarification: are you running SQL2000? (that's the forum you posted in).

    If yes I think one of the few ways in 2K to do it is to have...


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

    #1157060

  • RE: Summary query from 2 tables

    What have you tried so far?

    We're here to help you, not to substitute you...

    Also, please read and follow the first link in my signature on how to ask for 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]

    April 23, 2010 at 11:51 am

    #1157050

  • RE: Speed improvement help needed for large xml queries

    Would you mind providing a short example of one of your xml file so we have something to test our solution against? Would help (at least me...)


    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 23, 2010 at 11:47 am

    #1157047

  • RE: getting a sum of a sum

    Please provide table def and (fake) sample data together with your expected result in a ready to use format to show what you're struggling with.

    If you need assistance please have...


    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 23, 2010 at 11:40 am

    #1157045

  • RE: xml queries

    What is the reason behind the requirement to loop through the XML?

    You could get a table based on the xml:

    SELECT

    Z.Itemnmbr,

    Z.Node.value('PromotionCode[1]','varchar(30)') AS PromotionCode

    FROM

    (SELECT

    w.value('Itemnmbr[1]','varchar(100)') AS Itemnmbr,

    X.Y.query('.') AS Node

    FROM...


    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 23, 2010 at 10:45 am

    #1157023

  • RE: Service Broker -- Where to start

    You could start search BOL (BooksOnLine, the SQL Server help system) for "Service Broker, catalog views". The result will be a list of system views related to SB. One of...


    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 22, 2010 at 4:11 pm

    #1156503

  • RE: any way to do this in SQL?

    quayludious (4/22/2010)

    I had attached a source file example... its the <magic happens here> part of getting the external mess to the internal hotness that eludes me...

    Unfortunately, your source file 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]

    April 22, 2010 at 4:05 pm

    #1156501

  • RE: any way to do this in SQL?

    Hmmm, now we have the SQL for the result set. But how about the source 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]

    April 22, 2010 at 3:43 pm

    #1156493

  • RE: Converting to DateTime

    Glad I could help 😀

    One more thing to notice:

    you shouldn't use that code within a WHERE clause.

    Instead, convert the parameter you query against using something like

    WHERE mycol > = DATEDIFF(ss,'19700101',@MinDate)

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

    #1156484

  • RE: Help with ranking functions

    Ok, here's a sample that might get you started:

    DECLARE @tbl TABLE

    (

    val CHAR(1)

    )

    INSERT INTO @tbl

    SELECT 'a' UNION ALL

    SELECT 'a' UNION ALL

    SELECT 'a' UNION ALL

    SELECT 'a' UNION ALL

    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]

    April 22, 2010 at 3:25 pm

    #1156477

  • RE: any way to do this in SQL?

    Looks like a job for DynamicCrossTab. See the related link in my signature.

    Side note: If you'd like to see a coded sample based on your data please provide ready 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 22, 2010 at 3:13 pm

    #1156465

  • RE: Converting to DateTime

    I'm just guessing here but it seems like those are the seconds based on a start date (I don't know the startdate though, so just guessing...)

    SELECT DATEADD(ss,1271782698,'19700101')

    /*Result

    2010-04-20 16:58:18.000

    */


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

    #1156459

Viewing 15 posts - 3,691 through 3,705 (of 5,502 total)