Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    153

    Unanswered: updation of data in every 7 days

    Hi guys.

    i have 2 doubts
    1) iam getting data in a table from another table and i want those data to get inserted in every 7 days.




    2) i have created a view on multiple tables and iam getting data in my view from those tables. i want to update / get data in that view in every 7 days .


    Kindly provid eme any of the solution.

    Thank you.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    First: You posted this in the SQL Server and PostgreSQL forum.
    Which database are you really using?

    Second: you need to be a lot more specific about what you want. I have no idea what "to get inserted in every 7 days" should mean.

    Remember the golden rules for posting:

    - Post the structure of your table(s) by posting the necessary CREATE TABLE statements
    - Post some sample data (ideally as INSERT INTO statements, so that we can create a test case easily)
    - Post the expected output based on that sample data

    And make sure all your SQL is readable by formatting it using [code] tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •