Forum Replies Created

Viewing 15 posts - 3,736 through 3,750 (of 5,502 total)

  • RE: How to merge two text files into one text file using extended stored procedure??

    The easiest way would be to to xp_cmdshell for it:

    exec xp_cmdshell 'copy c:\temp\test1.txt + c:\temp\test2.txt c:\temp\test3.txt /y'

    But, like with some other solutions which look simple at a first glance there...


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

    #1154094

  • RE: How to order rows as specified

    To expand Waynes suggestion:

    Instead of changing "\ n" into commas you could add another column to your spreadsheet with incrementing values and add another column with a formula that creates...


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

    #1154068

  • RE: Database Mail Profile

    You might want to search BOL for "Database Mail [SQL Server], configuration scripts".

    There are links to sample procs you could use/modify.


    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 19, 2010 at 11:21 am

    #1154019

  • RE: I dont want using cursor

    Step one would be to find the relevant rows in @t1. Those would be the latest selldte per TID. To find those, you can use a CTE (see BOL for...


    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 18, 2010 at 3:12 am

    #1153450

  • RE: Are the posted questions getting worse?

    Is Google down?


    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 18, 2010 at 2:45 am

    #1153447

  • RE: Template for Data Flow in Sale Systems

    Here is a list of related web-sites that should get you started.


    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 18, 2010 at 2:42 am

    #1153446

  • RE: Pivoting name value pairs

    Please have a look at the CrossTab and DynamicCrossTab articles referenced in my signature.

    I think those articles will answer any questions you have regarding this pivoting issue...


    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 17, 2010 at 6:50 pm

    #1153423

  • RE: How to tune/speed up a procedure

    sagheeremail (4/17/2010)

    I have similar situation but it doesn't take 24 hours for my ETL process of converting 3+ M records to finish. It takes my ETL pross less than 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]

    April 17, 2010 at 6:45 pm

    #1153422

  • RE: Flag MIN - MAX of a Trigger Grouping

    Your requirement is not clear. The way you describe it, it should already be covered with the quirky update. If not, please be a little more descriptive.

    Btw: it's 2:30am over...


    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 17, 2010 at 6:38 pm

    #1153419

  • RE: Flag MIN - MAX of a Trigger Grouping

    Seems like the requirement calls for the quirky update (see Jeffs great article [/url] for details.

    Side note: I decided to use a temp table to show the concept. As...


    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 17, 2010 at 1:39 pm

    #1153384

  • RE: Template for Data Flow in Sale Systems

    What exactly is your question related to SQL Server?


    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 17, 2010 at 1:15 pm

    #1153383

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/17/2010)

    Hey guys, thanks again for everything. Just to let you know, I haven't read through Lutz's cte version of that last update yet, just read the first part 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 17, 2010 at 11:13 am

    #1153368

  • RE: How to tune/speed up a procedure

    WayneS (4/17/2010)

    lmu92 (4/17/2010)

    @Wayne: we're getting closer to the 00:45 you've been talking about 😀

    We probably will even be able to beat it!

    That's what I'm talking about!

    So, what the goal? 0:30?...


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

    #1153322

  • RE: How to tune/speed up a procedure

    When we started with c.u.r.s.o.r. stuff I didn't notice how similar the handling is. Now, seeing the set based code, it becomes more obvious.

    Therefore, I'd recommend the next step:

    If you...


    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 17, 2010 at 7:04 am

    #1153319

  • RE: How to tune/speed up a procedure

    Ok, here's what I came up with:

    I'm using a CTE again. The first one ("cte") is used to pivot the failed ConversionDataID's.

    The second CTE ("cte_ri") pivot the inserted ConversionDataID's 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 17, 2010 at 6:55 am

    #1153316

Viewing 15 posts - 3,736 through 3,750 (of 5,502 total)