Forum Replies Created

Viewing 15 posts - 3,961 through 3,975 (of 5,502 total)

  • RE: T-Sql Problem

    What type of guidance do you ask for?

    The kind of "Follow that path over there until you reach a crossroad at the hill. Then take a left because if you'd...


    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]

    March 16, 2010 at 4:24 pm

    #1134903

  • RE: dynamic sql example

    The following code worked as bad as a [c u r s o r] is supposed to but at least it gave the expected result (had to change it 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]

    March 16, 2010 at 4:09 pm

    #1134896

  • RE: dynamic sql example

    You need to assign to @Tablename instead of @x in your first fetch statement.

    Also, just use "set @x ='select..."

    instead of "set @x =@x+'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]

    March 16, 2010 at 3:43 pm

    #1134876

  • RE: insert data in batches

    The Dixie Flatline (3/16/2010)

    Hey Lutz 🙂 I beat you to the punch for once !! 😀

    You probably benefit from the time zone difference / foreigner issues...


    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]

    March 16, 2010 at 3:34 pm

    #1134872

  • RE: Conditionally Execute A Stored Procedure

    If you want it to retry the step you have to define the status "failed".

    That can either be done within your sproc uspMortgageData or you define an raiserror() statement 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]

    March 16, 2010 at 3:30 pm

    #1134870

  • RE: insert data in batches

    One more side effect of the "bouncing method": sometimes it's done row by row (get one row from the source table and insert it into the target table). That 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]

    March 16, 2010 at 3:12 pm

    #1134855

  • RE: T-Sql Problem

    Why do you need to run a cursor for what you're trying to do?

    Wouldn't it be easier to do it set based? As a start something like

    SELECT empid,

    SUM(CASE...


    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]

    March 16, 2010 at 3:07 pm

    #1134850

  • RE: sql server internationalization

    Another subject you need to focus on is how you handle date formates both within your tables (e.g. stored as character... :pinch:), and within all queries/stored procedures.

    If you provide any...


    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]

    March 16, 2010 at 2:43 pm

    #1134826

  • RE: How to loop through buffer table and pass each record value to another SP?

    Please explain a little more detailed what you're trying to do. Especially in terms of the stored procedure.

    It might be the case you're trying to do a row-based approach where...


    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]

    March 16, 2010 at 2:32 pm

    #1134815

  • RE: Conditionally Execute A Stored Procedure

    It seems like you're trying to do an existence check and run the proc based on the result. If so, the following code should work.

    Note: it checks if there 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]

    March 16, 2010 at 2:28 pm

    #1134809

  • RE: GROUP BY in SSIS SQL Query for 35+ million rows

    I'd say there is a mismatch between the table size you're using and the size you allow tempdb to grow to. You'd fill one of those tempdb files completely 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]

    March 16, 2010 at 1:36 pm

    #1134769

  • RE: Converting row to columns

    Step 1:

    use a split string fuction to separate your comm separated list (for a sample function please see the tally table link in my signature).

    Step 2:

    Either use PIVOT or a...


    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]

    March 16, 2010 at 1:22 pm

    #1134763

  • RE: Sending SMS through Stored Procedures???

    Did you try to google for a solution?

    I just tried "sql server sms" as key words and found several solutions.

    One is

    http://www.siccolo.com/Articles/SQLScripts/how-to-create-trigger-to-sms-email.html

    But there are a lot more....


    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]

    March 16, 2010 at 1:15 pm

    #1134761

  • RE: Extract Monthly report but Different DATE Format data into SQL server 2005 Database

    The easiest way would be to change your columns from varchar into datetime format. You could add another column each with datetime format and copy the varchar values into 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]

    March 16, 2010 at 12:57 pm

    #1134749

  • RE: Splitting A String

    Paul White (3/16/2010)

    ...

    Yikes. XML is not the right tool for the job when it comes to string splitting.

    The tally-table method presented by Lutz, Bob, and Jeff is far,...


    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]

    March 16, 2010 at 12:18 pm

    #1134713

Viewing 15 posts - 3,961 through 3,975 (of 5,502 total)