Forum Replies Created

Viewing 15 posts - 2,476 through 2,490 (of 5,502 total)

  • RE: get Data previous on the same row for 4 previous columns

    Something like this?

    ;WITH cte AS

    (

    SELECT ROW_NUMBER() OVER(ORDER BY quote_date ) AS ROW, *

    FROM #priceData

    )

    SELECT

    cte1.*,

    cte2.close_price AS Previous1,

    cte3.close_price AS Previous2,

    cte4.close_price AS Previous3,

    cte5.close_price AS Previous4

    FROM

    cte cte1

    LEFT...


    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 5, 2010 at 3:53 am

    #1258811

  • RE: result problems in sql views

    Please post table def inclding foreign key refernces and some sample data as described in the first link in my signature. Also please post your expected output based on 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 5, 2010 at 3:22 am

    #1258810

  • RE: accessing ssrs2008 reports remotely with my systems IP without IIS

    Please don't cross post!

    Replies at http://www.sqlservercentral.com/Forums/FindPost1030262.aspx


    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 4, 2010 at 6:24 am

    #1258746

  • RE: accessing ssrs2008 reports remotely with my systems IP without IIS

    Please don't cross post!

    Replies at http://www.sqlservercentral.com/Forums/FindPost1030262.aspx


    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 4, 2010 at 6:24 am

    #1258745

  • RE: accessing ssrs2008 reports remotely with my systems IP without IIS

    Please don't cross post!

    Replies at http://www.sqlservercentral.com/Forums/FindPost1030262.aspx


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

    #1258744

  • RE: two insert statments takes long time to process

    Edit: never mind. Misread the question


    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 4, 2010 at 5:46 am

    #1258743

  • RE: Huge tables with no appropriate column for creating clustered index !

    Another issue might be the table design by itself.

    If you don't have a column that uniquely identifies a row, then your table structure isn't normalized.

    The downside of it: you'll need...


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

    #1258732

  • RE: Best practice setup in sp_configure?

    amy26 (12/2/2010)

    Cool thanks again, I actually edited my post after I just used google to look up the answer to my question! 🙂 I didn't realize we had actually...


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

    #1258671

  • RE: Best practice setup in sp_configure?

    amy26 (12/2/2010)

    Cool thanks some good advice. So, setting the parallelism to zero means it won't be using any parallelism right?

    Nope. The opposite.

    Curently, you have it set to 1, meaning...


    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 2, 2010 at 3:49 pm

    #1258157

  • RE: Best practice setup in sp_configure?

    amy26 (12/2/2010)

    About the parallelism: I was told that I should set this setting less than the available CPUs that are on the server. As we only have 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]

    December 2, 2010 at 3:29 pm

    #1258151

  • RE: Best practice setup in sp_configure?

    Here are the ones I'm concerned about:

    max degree of parallelism1

    Are you sure to prevent parallel processing on the server level? Is the server mainly used for OLAP or OLTP processes?

    Ole...


    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 2, 2010 at 1:58 pm

    #1258119

  • RE: Remove the first character of a string

    samartel (12/2/2010)

    Wow....go grab a coffee and my post has a bunch of solutions....lol

    I think what i'm going to do is actually redirect the file as an error. As GSquared...


    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 2, 2010 at 1:33 pm

    #1258099

  • RE: Remove the first character of a string

    Craig Farrell (12/2/2010)

    LutzM (12/2/2010)

    In that case, either an IIF statement or REGEX should help. (Google regex or IIF in ssis for details.)

    You'd basically use a script component after your data...


    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 2, 2010 at 12:36 pm

    #1258066

  • RE: Remove the first character of a string

    In that case, either an IIF statement or REGEX should help. (Google regex or IIF in ssis for details.)

    You'd basically use a script component after your data import to remove...


    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 2, 2010 at 12:27 pm

    #1258056

  • RE: How to Combine redundant values into one field using stored procedure!

    You might want to search this site for "string concatenate for xml path".

    I'm sure FOR XML PATH will do the trick.


    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 2, 2010 at 11:51 am

    #1258033

Viewing 15 posts - 2,476 through 2,490 (of 5,502 total)