Forum Replies Created

Viewing 8 posts - 16 through 24 (of 24 total)

  • RE: Is there a better way?

    The insertion order matters because when I read the data back in my hierarchy information is built/displayed starting from the top on down.

    Clustered Primary Key? Would that be like...


    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

  • RE: Is there a better way?

    Thanks for the suggestion.

    For some reason I thought I had tried that and what happens is the records do disappear. But tne new table does not have the records in...


    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

  • RE: How to return a quarter for every person

    Your assumption is correct. We felt we had to prepop a quarter table to get out what we wanted.


    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

  • RE: How to return a quarter for every person

    Absolutely incredible. Thank you very much. I had no idea what a cross join was or that it even existed. We are cheering in the streets here.


    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

  • RE: WHERE IN help needed

    Thanks.

    I don't plan on the in list being more than 50 people. But who knows.


    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

  • RE: WHERE IN help needed

    I must have had another issue. It seems to be working now.

    Thank you all for the function, etc. I learned quite a bit - for example I did not...


    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

  • RE: WHERE IN help needed

    I tried that split you gave me and like I thought it is splitting OK. I get a vertical array.

    I should clarify what I am trying to do. The select...


    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

  • RE: WHERE IN help needed

    Thanks all for the response.

    Should this work with a view also? Here is the query I want it to go into and it still will not work with the...


    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

Viewing 8 posts - 16 through 24 (of 24 total)