Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Constraint problem

Constraint problem

Scheduled Pinned Locked Moved ASP.NET
helpdatabasesql-serversysadminquestion
3 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Offline
    C Offline
    Commickey
    wrote on last edited by
    #1

    Hello, I am designing a webapplication that has plan_courses and courses_followed table. It is required that after the planned date, an alert should be seen that will ask the administrator if the student followed the planned course or not and if yes, the record should automatically be inserted into the courses_followed table and delete from the plan_courses and if no, it should be deleted from the plan_courses table. Does anyone know how I can even start with this puzzle? Sample codes will be of great help, I am using SQL Server Thanks a lot Commickey

    V 1 Reply Last reply
    0
    • C Commickey

      Hello, I am designing a webapplication that has plan_courses and courses_followed table. It is required that after the planned date, an alert should be seen that will ask the administrator if the student followed the planned course or not and if yes, the record should automatically be inserted into the courses_followed table and delete from the plan_courses and if no, it should be deleted from the plan_courses table. Does anyone know how I can even start with this puzzle? Sample codes will be of great help, I am using SQL Server Thanks a lot Commickey

      V Offline
      V Offline
      Vasudevan Deepak Kumar
      wrote on last edited by
      #2

      SQL Jobs can help you out with this right? Vasudevan Deepak Kumar Personal Homepage namespace LavanyaDeepak
      Personal Weblog
      The World of Deepak and Lavanya
      ViewPoint 24x7

      C 1 Reply Last reply
      0
      • V Vasudevan Deepak Kumar

        SQL Jobs can help you out with this right? Vasudevan Deepak Kumar Personal Homepage namespace LavanyaDeepak
        Personal Weblog
        The World of Deepak and Lavanya
        ViewPoint 24x7

        C Offline
        C Offline
        Commickey
        wrote on last edited by
        #3

        Yes... that can be true but how do I go about it? I need a starting point... that is where I need the help

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups