Post reply

Between Statment only for current day

  • July 17, 2010 at 5:32 am

    #1194506

    Jon, are you permitted to create/amend stored procedures? What about tables?

    Why does the code have to be run twice per second when the returned values will change little in that time?

    SQL is being feed data remotely from a financial charting package, the data sent to SQL is totals, they will change every 500ms, SQL is being used as push into and the draw put of across different programs, the data is then analysis with price movement, so 500ms if fair, even a small change in data will have results as I work in frequency analysis so, so time and price are linked, I must have equal time bins to work, that is why I keep drawing off the data.

    How can I check that I am permitted to create and amend tables? I thought my login was setup as admin so i dont have any restrictions.

    Jon

  • July 18, 2010 at 11:49 am

    #1194643

    jon pill (7/17/2010)

    How can I check that I am permitted to create and amend tables?

    Just try it manually, I guess.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 46 through 46 (of 46 total)

You must be logged in to reply to this topic. Login to reply