Post reply

Date Query Format Problem

  • September 3, 2012 at 10:19 am

    #1533026

    jerome.morris (9/3/2012)

    Hi Jefff, where am I going wrong with this query please

    You're not providing the information I asked for... that's where. 😉

    Also, the conversion you're doing to datetime in the code will be a real performance killer but I can't help because you haven't provided the info I asked for.

    --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)
    Intro to Tally Tables and Functions

  • September 3, 2012 at 10:27 am

    #1533029

    Sorry Jeff, performance as it stands is not that bad. Originally the report where done using access and generating a report from that took 5mins, even using the method I posted its 90% faster

    Jay

    Thank you kindly for all you help

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

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