Forum Replies Created

Viewing 15 posts - 1,651 through 1,665 (of 2,452 total)

  • RE: creating an investment data warehouse

    Matthew Cushing (5/13/2013)


    J Livingston SQL (5/13/2013)


    Matthew Cushing (5/13/2013)


    So if I have 5 shares of IBM that are worth 100$, 10 shares of Microsoft worth 200$, my position right now is...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: creating an investment data warehouse

    Matthew Cushing (5/13/2013)


    So if I have 5 shares of IBM that are worth 100$, 10 shares of Microsoft worth 200$, my position right now is $300.

    is this a typo ...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: I would REALLY like some fast help with this problem!

    hamed1337 (5/12/2013)


    The problem is this, the game has databases from 2000 and therfore i need SQL 2000.

    It's not supported? Well, maybe i will get help from someone that knows a...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: I m using MS-SQL server 2005, and i want to schedule job on the interval of 15 day

    RRPA (5/11/2013)


    Hi just to correct mine wording. i need to schedule backup on the alternate Sunday.

    edit job schedule as per Gails post above

    frequency > weekly

    recurs every > 2

    tick "Sunday"

    does this...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Query Help

    jagat.patel (5/9/2013)


    I have following table

    IDActiveFalgDate

    10 1/1/2013

    10 2/1/2013

    11 3/1/2013

    10 ...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SQL server as a back end for Access

    interesting comment here

    http://www.sqlservercentral.com/Forums/FindPost1450729.aspx

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SQL statement for new vs duplicate data

    <deleted>....not working as required

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: How to Insert/Upadte data based on exist in mathcin table, in single query

    asita (5/7/2013)


    please help me

    Kind Regards

    asittti

    for me at least...it would help to see what you currently have coded..as per your original comment below.

    how to write this statement in more optimized manner...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Data transfer while dynamic increment of duplicate values.

    can you please do as asked

    Neeraj Dwivedi (5/6/2013)


    Also I need data in the form of script where I can insert that in my environment without writing the code.

    the...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SQL server as a back end for Access

    Todd...if you go down the Access route then here is a good resource

    http://www.utteraccess.com

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SQL server as a back end for Access

    as a start...worth reading

    http://msdn.microsoft.com/en-us/library/hh313039.aspx

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SQL server as a back end for Access

    todd.ayers (5/7/2013)


    are these existing Access dbs that you want to upgrade to SQL?

    you say you have six weeks experience in MS Access...what SQL experience?

    ever designed a front end app before?

    I...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SQL server as a back end for Access

    todd.ayers (5/7/2013)


    The applications consist of an inventory manager db, a workorder db, an ops db, and a lumber inventory db. Each of these databases have multiple tables on the back...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SQL server as a back end for Access

    whats the application going to do?

    how many users?

    what volume of data are you expecting to store in SQL

    are users on the LAN or WAN?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: SQL server as a back end for Access

    todd.ayers (5/7/2013)


    Looking for good and/or bad reasons to use SQL server as a back end component to access 2007 and use the Forms and Reports of Access as the GUI...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 15 posts - 1,651 through 1,665 (of 2,452 total)