Forum Replies Created

Viewing 15 posts - 44,821 through 44,835 (of 59,063 total)

  • RE: column to calculate the balance stock dynamically

    Lynn Pettis (3/3/2009)

    Jeff Moden (3/3/2009)

    Lynn Pettis (3/3/2009)

    Oh, wow. Looks like I may have beat Jeff. But of course, he is probably setting up a million row example to...

    March 3, 2009 at 9:57 pm

    #952860

  • RE: column to calculate the balance stock dynamically

    Samuel Vella (2/26/2009)

    mh, your solution is fine but when you test it with a lot of data against a cursor, the cursor is orders of magnitude faster

    Man, you have absolutely...

    March 3, 2009 at 9:56 pm

    #952858

  • RE: column to calculate the balance stock dynamically

    beezell (3/3/2009)

    Hmmm... there are very few scenarios where I've seen cursors faster than CTE or non-RBAR (row by agonizing row) methods. Just curious how many rows you're running through?

    Cheers,

    Brian

    That's...

    March 3, 2009 at 9:20 pm

    #952850

  • RE: column to calculate the balance stock dynamically

    Lynn Pettis (3/3/2009)

    Oh, wow. Looks like I may have beat Jeff. But of course, he is probably setting up a million row example to demonstrate his code, where...

    March 3, 2009 at 9:14 pm

    #952849

  • RE: column to calculate the balance stock dynamically

    Samuel Vella (2/24/2009)

    The problem with these sorts of calculations is that a row of data in a database is completely independant. It does not know or care about its neighbours...

    March 3, 2009 at 8:19 pm

    #952841

  • RE: Question on following sql

    nymgk_75 (3/3/2009)

    IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE name LIKE '#FileSpaceStats%')

    BEGIN

    DROP TABLE #FileSpaceStats

    END

    Thanks

    Ugh! That's actually the wrong way to do it. Here's the correct way... it...

    March 3, 2009 at 8:09 pm

    #952838

  • RE: Aggregate Function / Group By

    I can show you a little performance trick (big one, actually) but I need to know which table the following column is in...

    ...

    March 3, 2009 at 8:02 pm

    #952836

  • RE: How to exit out ofa script if it fails Halfway during execution?

    Heh... why can't you just remove the GO's?

    March 3, 2009 at 7:57 pm

    #952835

  • RE: HELP ME

    I believe the question is how to capture/audit all rows from all tables anytime any of them suffers an insert/update/delete.

    And, I agree... it's either the language barrier getting to me...

    March 3, 2009 at 7:55 pm

    #952834

  • RE: Query for "as of Date"

    Dang smiley faces... I wish they wouldn't show up in code windows but still show in the rest of the post if desired. If you want to get rid...

    March 3, 2009 at 7:46 pm

    #952833

  • RE: Normalization

    Table B looks like a typical "mapping" table in a many-to-many relation ship. It must be populated manually since there's no way to accomplish the task automatically short of...

    March 3, 2009 at 7:43 pm

    #952832

  • RE: Deleting data from large tables.

    So you're trying to delete 300/30 or about 10 million rows per day? If you only delete 1000 rows every 10 minutes, that means that you would need 10,000...

    March 3, 2009 at 7:31 pm

    #952829

  • RE: Select distinct row on SQL 2000. Please help me!

    tuyetmuadong (3/3/2009)

    Hi everybody,

    I want to distinct value on one column, but get all column of data. How is query in SQL 2000 ?

    For example: I have a table PK003_INDEX(LINK,...

    March 3, 2009 at 7:19 pm

    #952822

  • RE: Inserting the return from a split function to a table

    Thomas Mick (3/3/2009)

    Thank you for your reply. Unfortunately it still doesn't provide a solution to my particular problem. Its not the split that I am having difficulty with, but how...

    March 3, 2009 at 7:16 pm

    #952821

  • RE: Query Help

    barunpathak (3/2/2009)

    Outer APPLY worked guys. Thats a bunch for your help.

    Two way street here... post your final code so we can enjoy it, please. 😉

    March 3, 2009 at 7:09 pm

    #952818

Viewing 15 posts - 44,821 through 44,835 (of 59,063 total)