Forum Replies Created

Viewing 15 posts - 2,071 through 2,085 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (1/18/2011)

    Steve Jones - SSC Editor (1/18/2011)

    Well this is a depressing few pages in The Thread.

    I could make it worse, but I think maybe I'll decline to

    Let me guess: News...


    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]

    January 18, 2011 at 11:53 am

    #1274916

  • RE: Report Model Security!!!

    duplicate post. please continue


    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]

    January 18, 2011 at 11:39 am

    #1274910

  • RE: Deadlock at primarykey column

    GilaMonster (1/18/2011)

    Consider a nonclustered index on (JobCardID, StageID, SubJobID, IsActive, CompletedDate, QueueID)

    Gail, is there any specific reason to use all columns in the index instead of moving some to 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]

    January 18, 2011 at 10:36 am

    #1274873

  • RE: Calculating Delta values for each day

    Something like this?

    Step 1: get the max value per day and number the result set.

    Step 2: perform a self join with a row offset of 1.

    ; WITH cte AS

    (

    SELECT

    ROW_NUMBER()...


    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]

    January 18, 2011 at 10:18 am

    #1274865

  • RE: baseline for read/writes

    Is there any specific reason for your duplicate post (here's the other one)?

    Based on your visit count I think you've been around long enough to know better...


    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]

    January 18, 2011 at 10:08 am

    #1274859

  • RE: avg calculation

    additionally, we have a duplicate thread.

    @sravanb

    After reevaluating the issues as Craig recommended, please take the time and read the first article referenced in my (and Craigs) signature on how 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]

    January 18, 2011 at 10:03 am

    #1274855

  • RE: calculating avg

    Is there any specific reason for starting two threads with the identical issue within one hour?

    (http://www.sqlservercentral.com/Forums/FindPost1049494.aspx) :angry:


    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]

    January 18, 2011 at 9:59 am

    #1274852

  • RE: avg calculation

    Why not using AVG() ... GROUP BY?

    Edit: and what do you consider as being a "recent value"? You'd need a date to compare against, but I can't find one: 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]

    January 18, 2011 at 9:47 am

    #1274839

  • RE: Mulitple procedure vs Single procedure

    CELKO (1/17/2011)

    ...

    But thanks to Texas oil money, I can get a dictionary of a dead language :crying:

    You're not talking about ANSI92 SQL "standard", are you? :hehe:

    Edit: Over here in Europe...


    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]

    January 17, 2011 at 4:50 pm

    #1274426

  • RE: SQL Dilemma

    Next try:

    First, select all signdate values and cross check it against the original table if there is a different client and the signdate is within the others client time.

    ; WITH...


    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]

    January 17, 2011 at 4:48 pm

    #1274425

  • RE: SQL Dilemma

    Ooopss!! Completely misunderstood the issue... I'm sorry!

    I thought you were looking for overlapping time intervals...

    Let's see if I can find a way....


    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]

    January 17, 2011 at 4:39 pm

    #1274423

  • RE: SQL Dilemma

    Here's an approach just based on selecting the data.

    The basic concept: Unpivot the data to get on row per start and one per end date.

    Based on the unpivoted data two...


    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]

    January 17, 2011 at 3:46 pm

    #1274409

  • RE: Please help with SQL code

    Jeff,

    I'm expecting the sample section to be

    [POL_COUNTRY_CD] [nvarchar](2) NULL,

    [POL_LOCATION_CD] [nvarchar](5) NULL,

    [POD_COUNTRY_CD] [nvarchar](2) NULL,

    [POD_LOCATION_CD] [nvarchar](5) NULL,

    At least that's what the sample data look like.

    The new columns are [POL_LOCATION_CD] and [POD_LOCATION_CD]. Those...


    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]

    January 17, 2011 at 1:42 pm

    #1274385

  • RE: need to get 1 row/record

    anand_vanam (1/17/2011)

    Just for curiosity..

    if we don't know the maximum numbers of mac_address's associated for the Name.

    Say here we have 4 mac_address associated with the Name "sn4051536", so went 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]

    January 17, 2011 at 1:28 pm

    #1274377

  • RE: Mulitple procedure vs Single procedure

    CELKO (1/17/2011)

    You were asleep in your freshman Software Engineering class! Coupling? Cohesion? Remember all that stuff?

    Each module of code should have one entry and one exit point. Each...


    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]

    January 17, 2011 at 11:47 am

    #1274345

Viewing 15 posts - 2,071 through 2,085 (of 5,502 total)