Forum Replies Created

Viewing 15 posts - 751 through 765 (of 5,502 total)

  • RE: Subquery example

    ... especially if the old syntax is lacking the WHERE clause in the given example.... 😉


    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]

    December 29, 2011 at 2:31 pm

    #1426722

  • RE: Query Result in Mail

    Wouldn't it be a lot easier to use sp_send_dbmail?

    For the @query_attachment_filename parameter, use a xls file extension.


    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]

    December 29, 2011 at 2:06 pm

    #1426713

  • RE: Creating SSIS Package with XML Source

    I strongly recommend you immediately remove the obviously real data, unless you have proper authorization from each and every company you've listed!!

    Replace the data with obfuscated values.

    Edit: to post 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]

    December 28, 2011 at 3:02 pm

    #1426272

  • RE: Database Designing issue

    Back to the original question:

    Let's assume the travel ageny will offer cruises as well. How would you include it in the design you have in mind?

    What would happen 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]

    December 28, 2011 at 10:51 am

    #1426189

  • RE: Equivalant of "Left Join" but in XML

    I'm not sure if the method described in Jacobs Blog would be a start for a dynamic shredding solution...

    There's also a reference to the related XQuery method

    Due to the natural...


    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]

    December 28, 2011 at 8:10 am

    #1426101

  • RE: Equivalant of "Left Join" but in XML

    Jeff Moden (12/25/2011)

    I see you've added "mind reading" to your list of skills. That was going to be my next question if I couldn't suss it on my own....


    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]

    December 25, 2011 at 5:30 pm

    #1425445

  • RE: Equivalant of "Left Join" but in XML

    Here's a short example of the table-based version using your original sample data.

    CREATE TABLE #tmpXML

    (

    TmpID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

    XmlCol XML

    )

    INSERT INTO #tmpXML (XmlCol)

    VALUES (@XmlData)

    CREATE PRIMARY XML INDEX...


    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]

    December 25, 2011 at 5:24 am

    #1425415

  • RE: Equivalant of "Left Join" but in XML

    One more question:

    How large is the XML structure?

    It might help to insert the data into a table with an indexed xml column.

    Under certain conditions the additional time to create 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]

    December 24, 2011 at 4:26 pm

    #1425381

  • RE: Equivalant of "Left Join" but in XML

    OUTER APPLY is your friend here, too 😀

    Please note I decided to use some totally meaningless alias names so you can easily identify the code that's not your original 😎

    This...


    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]

    December 24, 2011 at 3:46 pm

    #1425377

  • RE: Please help with a simple query, I need to group data in a certain way (example available)

    I'd rather use the good old CrossTab approach as described in the related link in my signature.

    It'd not only easier to remember but usually also faster than the PIVOT.


    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]

    December 24, 2011 at 3:33 pm

    #1425373

  • RE: Results to text

    peter 50174 (12/23/2011)

    What exactly are you struggling with?

    Do you already get the data in your VB script? If so, then it shouldn't be a problem to format it using VB....


    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]

    December 23, 2011 at 6:42 am

    #1425146

  • RE: Results to text

    peter 50174 (12/23/2011)

    Results to Text

    Returns the query results as text in the Results window.

    I want the result via the web. This means I'm using a VB.net...


    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]

    December 23, 2011 at 6:22 am

    #1425134

  • RE: Running Total - Split By Acct

    You didn't really use the anchor in your code.

    I've added AcctId to the code and assigned it to the anchor variable. Then I included the anchor to reset @PreviousBalance.

    DECLARE

    ...


    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]

    December 23, 2011 at 5:59 am

    #1425118

  • RE: Complex Join (?) problem

    Glad I could help 😀

    This example once again demonstrate how a "semi-optimal" database design usually increase query complexity...

    The sad part is, there are companies out there making money by selling...


    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]

    December 23, 2011 at 1:59 am

    #1425055

  • RE: Complex Join (?) problem

    Will something like this bring you closer to the result you're looking for?

    The information that there will never be more than two UOMs allows to use the ROW_NUMBER approach 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]

    December 22, 2011 at 2:48 pm

    #1424970

Viewing 15 posts - 751 through 765 (of 5,502 total)