Forum Replies Created

Viewing 15 posts - 18,436 through 18,450 (of 26,484 total)

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    I have found the "quirky update" useful when helping others who needed to capture and update intermediate results along with the final results of a calculation.

    It helps break down the...

  • RE: Cannot Insert Duplicate Keys message

    Hmmm, force is weak. See what you see I can't.

    It would help if you provided us with more information. Based solely on your post, it is extremely difficult...

  • RE: Error/problems with using UNION in combo with CURSOR

    EK rook (11/10/2009)


    Hey everbody,

    I have(or better yet tried to) create a cursor which acquires data from a table created from the union of two other tables in the same database,...

  • RE: Are the posted questions getting worse?

    Didn't even need to see the picture to know what it was ... 😛

    Interesting image, pork chops wearing kilts ... 😛

  • RE: Please review my small SSIS project demands.

    Posted several questions that may be relevant to anyone thinking about bidding on the project (I might even bid on the project).

    From what I saw in your pictures, the files...

  • RE: Date conversion into AM/PM Format

    And if it is decimal, how is it declared?

  • RE: Running Totals

    Jeff Moden (11/8/2009)


    Lynn Pettis (11/6/2009)


    Jeff Moden (11/6/2009)


    Lynn Pettis (11/6/2009)


    Jeff Moden (11/6/2009)


    ...

    What? No comments on the sample code I provided? I really thought you'd have more to...

  • RE: Running Totals

    Jeff Moden (11/6/2009)


    Lynn Pettis (11/6/2009)


    Jeff Moden (11/6/2009)


    ...

    What? No comments on the sample code I provided? I really thought you'd have more to add. 😉

    I'm not done...

  • RE: Running Totals

    Jeff Moden (11/6/2009)


    ...

    What? No comments on the sample code I provided? I really thought you'd have more to add. 😉

  • RE: Multiple Tables on same side of "On" clause

    lmeinke (11/6/2009)


    Hello All,

    I have a query that uses 6 joins to produce a results set. It is in the form of:

    Select A.field1, B.field2, C.field3, etc....

    From Table A

    Inner Join Table...

  • RE: CASE WHEN in WHERE clause

    Just because you have indexes on the tables doesn't mean they are the right indexes. Looking at the execution plan can help you determine if the indexes you have...

  • RE: DPM Drawbacks?

    Just took a cursory look at DPM. I'm going to have to look at it further and see what it can and can't do. May actually be worth...

  • RE: Best Practise

    s_shah-977123 (11/6/2009)


    Hi,

    This has probably been asked several times before, I have been using MS Access previously but now moving to SQL, my server has SQL 2005 workgroup edition installed.

    - Is...

  • RE: How to improve performance of the view with 12 joins

    Based on your post? No. Not enough information to be of real help. It would help to see the DDL for the view and the underlying tables....

  • RE: SQL + Win Server Licensing in a TEST ONLY lab environment??

    Ian Scarlett (11/6/2009)


    Lynn Pettis (11/6/2009)


    I thought there was a limit of 10 systems (computers).

    I don't think there is, Lynn... this is from the MSDN site

    MSDN subscriptions are licensed on a...

Viewing 15 posts - 18,436 through 18,450 (of 26,484 total)