Forum Replies Created

Viewing 15 posts - 1,201 through 1,215 (of 5,502 total)

  • RE: SQL: Modify XML values identified through cross apply

    Nice solution, MM!

    Would it be possible to set the flag to either "true" or "false" depending on the value of frac or would this require a second update?


    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]

    July 23, 2011 at 2:43 am

    #1357395

  • RE: SQL: Modify XML values identified through cross apply

    jonegerton (7/22/2011)

    That's a nice idea and I'll have a think about it, however my real world example has these problem nodes buried quite deeply in a large xml document stored...


    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]

    July 22, 2011 at 3:35 pm

    #1357329

  • RE: clarify some conecpts of SQL client

    sqlfriends (7/22/2011)

    Thanks, and what is the difference between native client and ssms?

    Straight off the web:

    The SQL Server Native Client...

    ...contains the SQL Server ODBC driver and the SQL Server OLE DB...


    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]

    July 22, 2011 at 3:29 pm

    #1357324

  • RE: clarify some conecpts of SQL client

    What do you define as a "SQL Server client"?

    If you want to access data on a server, you could either use SSMS or any type of ODBC connect (e.g. ACCESS,...


    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]

    July 22, 2011 at 2:23 pm

    #1357296

  • RE: SQL: Modify XML values identified through cross apply

    I'm not sure if there's an easy way to do it using XML DML, but here's a slightly different approach: shred the xml and rebuild it

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

    July 22, 2011 at 1:41 pm

    #1357279

  • RE: Index seek or Index scan

    As soon as you perform a SELECT * and you're looking for an index seek, you could either make Date the clustered index or add another index with all columns...


    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]

    July 22, 2011 at 11:16 am

    #1357200

  • RE: Nested XML - FOR XML PATH

    Are you looking for something along those lines?

    SELECT

    CustomerName AS '@name',

    (

    SELECT DiscountType AS 'discount/@name',

    DiscountRate AS 'discount'

    FROM @customer c2 WHERE c1.CustomerName=c2.CustomerName

    FOR XML PATH(''), type

    )

    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]

    July 22, 2011 at 11:08 am

    #1357197

  • RE: Companies that use SQL Server !

    I don't think we really disagree here, Elliott.

    However, I would not compare a decision between SQL and .NET with a decision between Oracle and SQL Server.

    To summarize it: "It depends."...


    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]

    July 22, 2011 at 1:31 am

    #1356882

  • RE: Companies that use SQL Server !

    Or, to rephrase my previous post and put it a litlle more toward your original question:

    have a look at the SQL Server related patches and what the fixes are about...


    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]

    July 21, 2011 at 2:54 pm

    #1356763

  • RE: Companies that use SQL Server !

    I'm not sure if it's a "short sighted" position:

    I'll have to deal with arguments like the number of viruses available to attack the systems and the risk/additional effort involved with...


    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]

    July 21, 2011 at 2:43 pm

    #1356753

  • RE: sql inbound error while executing - please help

    If you assign an alias like "ALE" to sep5.V_ALERTS you'll actually have to use it in your join syntax.

    Replace sep5.V_ALERTS with ALE


    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]

    July 21, 2011 at 2:26 pm

    #1356741

  • RE: sql inbound error while executing - please help

    or do you, by any chance, have table names with a period being part of the table name? :sick:

    Meaning sep5.V_ALERTS is not referring to table (view?) V_ALERTS in schema sep5...


    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]

    July 21, 2011 at 1:53 pm

    #1356714

  • RE: sql inbound error while executing - please help

    it might be this section of the code:

    left outer join sep5.V_SEM_COMPUTER s4 on sep5.V_ALERTS.COMPUTER_IDX = s4.V_SEM_COMPUTER.COMPUTER_ID

    There is an alias on "s4" on...


    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]

    July 21, 2011 at 1:45 pm

    #1356709

  • RE: Queries to get Security Information

    duplicate post. no replies please.

    Original post: http://www.sqlservercentral.com/Forums/FindPost1145610.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]

    July 21, 2011 at 1:16 pm

    #1356687

  • RE: Companies that use SQL Server !

    The fact it only runs on Windows is one of the biggest concerns to get SQL Server into a production environment:

    The production area usually is flooded with *IX OS together...


    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]

    July 21, 2011 at 12:15 pm

    #1356652

Viewing 15 posts - 1,201 through 1,215 (of 5,502 total)