Forum Replies Created

Viewing 15 posts - 4,426 through 4,440 (of 5,502 total)

  • RE: SQL Service Broker error (2K8)

    Unfortunately, I don't have an answer for you.

    But the Service Broker subject in general is not really one of the top issues discussed in this forum (I don't know why).

    Maybe...


    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]

    January 23, 2010 at 3:40 pm

    #1107841

  • RE: Query optimization

    lobbymuncher (1/23/2010)

    Hey Lutz, looks like I took your good advice 😉

    ... and you didn't even use a CTE ...

    Nabha's going to like it... 😀


    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]

    January 23, 2010 at 2:28 pm

    #1107829

  • RE: Need help to built SQL statement

    You're very welcome!

    And thank you for posting back. It's always good to get some feedback from the OP (= Original Poster = the person that opened a thread).

    It shows 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]

    January 23, 2010 at 1:10 pm

    #1107810

  • RE: Need help to built SQL statement

    Nabha (1/23/2010)

    I have seen lot of your solutions making use of CTE's lutz 🙂

    I can't really do anything about it: as soon as I think a subquery is required...


    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]

    January 23, 2010 at 12:49 pm

    #1107806

  • RE: convert varchar to numeric

    First of all you need to make sure to know what that value actually represents:

    It could be either 10000 or 10.

    Based on that you'd have to replace the comma 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]

    January 23, 2010 at 12:30 pm

    #1107797

  • RE: Need help to built SQL statement

    Did you notice that you've got two answers with sample code after that short time?

    The reason is simple: You provided ready to use sample data! Well done! 🙂

    Having two almost...


    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]

    January 23, 2010 at 12:16 pm

    #1107793

  • RE: Need help to built SQL statement

    I would use a CTE to join the two tables and use the FOR XML clause to get the results.

    ;WITH cte AS

    (

    SELECT RouteCd,rd.CoutCd,CoutDesc,SEQUENCE

    FROM @tRouteD rd

    INNER...


    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]

    January 23, 2010 at 12:12 pm

    #1107792

  • RE: Query optimization

    I would use the UNION operator (or even UNION ALL if possible) inside a CTE to get all values except AssetTypeName and join the CTE to the AssetType table.

    I would...


    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]

    January 23, 2010 at 5:44 am

    #1107737

  • RE: Finding duplicate row values

    @ malleswarareddy_m:

    Seems like your question is similar to your other thread : So, please don't cross post.


    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]

    January 23, 2010 at 5:26 am

    #1107736

  • RE: how to get only duplicate rows from table

    So, which solution did you try with your data and where did you get stuck?

    Please provide table definition, sample data, expected result and what you've tried so far as described...


    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]

    January 23, 2010 at 5:20 am

    #1107735

  • RE: Trying to store large text from a file

    The description provided so far is not as clear as it would be required to really help you...

    What do you mean by "need to bring in data from a report"?...


    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]

    January 23, 2010 at 5:19 am

    #1107734

  • RE: Msg 9420, Level 16, State 1, Line 1 XML parsing:

    If you can't post the real data that's causing the problem you'd need to come up with some modified sample data that will show the same effect.

    We need to be...


    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]

    January 23, 2010 at 3:26 am

    #1107725

  • RE: how to get only duplicate rows from table

    did you try to search for a solution already?

    If you type "find duplicate rows" in the search box (upper right side of the form) you'll find numerous solutions covering 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]

    January 23, 2010 at 3:18 am

    #1107724

  • RE: defining "Export to Excel" as a job which runs frequently

    Step 1:

    get the Export working outside of the job using your preferred way (e.g. from SSMS and save the export as SSIS package or use bcp or whatever).

    Step 2: wrap...


    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]

    January 23, 2010 at 3:07 am

    #1107722

  • RE: Sigh ... weird issue

    I cannot confirm what you describe. Please provide sample data that allow us to verify the scenario. The following works just as expected (no output):

    DECLARE @t TABLE (CodeName CHAR(2), ...


    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]

    January 22, 2010 at 4:15 pm

    #1107635

Viewing 15 posts - 4,426 through 4,440 (of 5,502 total)