Forum Replies Created

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

  • RE: MULTI PART IDENTIFIER -----error

    You only have [FINAL_DATA_ENTRY].[DBO].Journal in your FROM clause. You need to join it to [FINAL_DATA_ENTRY].[DBO].[TRADETABLE].

    I don't know the join type but something like

    INSERT INTO Tradetable (Journal_No)

    SELECT Journal.JournalNo

    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]

    April 17, 2010 at 5:19 am

    #1153306

  • RE: Issue with Stored Procedure

    Thank you for the update.

    It's always nice to have someone posting an update to his question even though the issue is not completely resolved (yet).


    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 16, 2010 at 5:52 pm

    #1153228

  • RE: Optimization: Turning a series of entries into columns

    Change

    PARTITION BY name

    to PARTITION BY id,name

    to get the cities numbered for each id.

    Should help a little... 😉


    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 16, 2010 at 5:49 pm

    #1153226

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/16/2010)

    Lutz, before I read your last post, I updated the Update statement for the previous permits, this will do the successful inserts, as well as the failed inserts all...


    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 16, 2010 at 5:44 pm

    #1153224

  • RE: Query 5000 Tables for data

    All I can think of is to use the undocumented sp_foreachtable (google for details) which really is looping through the tables.

    I'm not sure though, if this database design really 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]

    April 16, 2010 at 3:50 pm

    #1153187

  • RE: How to tune/speed up a procedure

    I would look at it the other way around:

    I would update the columns that failed based on the validity check of the "previous" permits to a value other than 0...


    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 16, 2010 at 3:33 pm

    #1153183

  • RE: Database Mail

    Did you try the steps suggested in BOL (BooksOnline, the SQL Server help system)? Especially the steps/views described in section "troubleshooting [SQL Server], Database Mail"?


    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 16, 2010 at 2:52 pm

    #1153151

  • RE: Best Invoicing Practices

    george.greiner (4/16/2010)

    ... Each client gets their own report so the business decision part is easy as I already know what that query / report will look like but I am...


    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 16, 2010 at 2:26 pm

    #1153140

  • RE: Help selecting latest records from database

    @dachen:

    Did you notice that there were almost 50 people reading your post and actually moved on?

    But as soon as there are ready to use sample data available, you already have...


    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 16, 2010 at 2:08 pm

    #1153134

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/16/2010)

    It might be required to catch the [PWDPermitConversionDataID] values and the column that failed for the rows holding bad values (using the OUTPUT clause applied to the error checking...


    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 16, 2010 at 2:00 pm

    #1153131

  • RE: Help selecting latest records from database

    Something like this? I'm not sure if it will meet your requirement but it should get you started...

    Side note: please notice how I did the setup of DDL and sample...


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

    #1153119

  • RE: Stored procedure Logic

    Would you mind providing a sample Excel file we can use (including the OPENROWSET statement you're using) and your expected output based on that sample data?

    Also, would you mind...


    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 16, 2010 at 1:25 pm

    #1153114

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/16/2010)

    I've been racking my brain on the very last step of this "previous" permit section...with just a yes or no, is it even possible to update the ConversionStatusPrevX fields...


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

    #1153105

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/16/2010)

    ...

    I always forget that. It's so bad for me that I've gotten into the habit of a) placing the database name in front of the table (like you've seen...


    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 16, 2010 at 10:57 am

    #1153025

  • RE: The best way to add next month

    The best way to deal with date values is to store it as date values.

    So, instead of having an integer value it woul be a lot better and easier 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]

    April 16, 2010 at 10:38 am

    #1153011

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