Home Forums SQL Server 2017 SQL Server 2017 - Development Auto fill table from a View RE: Auto fill table from a View

  • January 30, 2018 at 6:57 am

    #1977846

    davey3389 - Tuesday, January 30, 2018 6:50 AM

    Hi,

    I need some help with a project we are working on.

    I have a table containing 3 columns as followed:
    1. ID (auto number)
    2. Date (defaults to current date)
    3. User ID (foreign key from another table)

    I need this table to have the data entered into it automatically from a view that is run once a week (the view will pick one user ID at random).

    I hope this all makes sense

    Thanks in advance

    Ben

    I suggest that you write a stored procedure to do this for you and then schedule that to run as often as is required.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.