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. How to update records of a table automatically based on date

How to update records of a table automatically based on date

Scheduled Pinned Locked Moved ASP.NET
databasesql-serversysadminhelptutorial
13 Posts 5 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.
  • K Offline
    K Offline
    Krishhhhhhhhhhhhhh
    wrote on last edited by
    #1

    Am using MS sql server 2005 database. Table has 3 columns: 1)Id 2)Status 3)ExpireDate If Expire Date is today then status has to become false otherwise true. It has to done automatically. How to do it? Please help me

    L 1 Reply Last reply
    0
    • K Krishhhhhhhhhhhhhh

      Am using MS sql server 2005 database. Table has 3 columns: 1)Id 2)Status 3)ExpireDate If Expire Date is today then status has to become false otherwise true. It has to done automatically. How to do it? Please help me

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      This was already posted in the General Database forum. Please post in one forum only.

      K 1 Reply Last reply
      0
      • L Lost User

        This was already posted in the General Database forum. Please post in one forum only.

        K Offline
        K Offline
        Krishhhhhhhhhhhhhh
        wrote on last edited by
        #3

        No one has answered for this question yet. If anybody knows answer it

        L 1 Reply Last reply
        0
        • K Krishhhhhhhhhhhhhh

          No one has answered for this question yet. If anybody knows answer it

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #4

          Krishhhhhhhhhhhhhh wrote:

          No one has answered for this question yet. If anybody knows answer it

          Be patient, this site isn't set up to provide immediate answers.

          K 1 Reply Last reply
          0
          • L Lost User

            Krishhhhhhhhhhhhhh wrote:

            No one has answered for this question yet. If anybody knows answer it

            Be patient, this site isn't set up to provide immediate answers.

            K Offline
            K Offline
            Krishhhhhhhhhhhhhh
            wrote on last edited by
            #5

            Then y u r there? I think To check cross post only?

            L 1 Reply Last reply
            0
            • K Krishhhhhhhhhhhhhh

              Then y u r there? I think To check cross post only?

              L Offline
              L Offline
              Lost User
              wrote on last edited by
              #6

              No, I'm looking for questions to answer, but when I read the same question more than once I (like many others here) point out that you are abusing the forums. There is a protocol to be followed here and maybe if you are new you are not aware of it. Read the guidelines[^] for more information.

              K 1 Reply Last reply
              0
              • L Lost User

                No, I'm looking for questions to answer, but when I read the same question more than once I (like many others here) point out that you are abusing the forums. There is a protocol to be followed here and maybe if you are new you are not aware of it. Read the guidelines[^] for more information.

                K Offline
                K Offline
                Krishhhhhhhhhhhhhh
                wrote on last edited by
                #7

                I am not new to this. Check ur database since how long am using this. then talk to me.

                L 1 Reply Last reply
                0
                • K Krishhhhhhhhhhhhhh

                  I am not new to this. Check ur database since how long am using this. then talk to me.

                  L Offline
                  L Offline
                  Lost User
                  wrote on last edited by
                  #8

                  Krishhhhhhhhhhhhhh wrote:

                  I am not new to this.

                  Then you have no excuse for i) Crossposting ii) Not knowing the guidleines iii) being rude.

                  K 1 Reply Last reply
                  0
                  • L Lost User

                    Krishhhhhhhhhhhhhh wrote:

                    I am not new to this.

                    Then you have no excuse for i) Crossposting ii) Not knowing the guidleines iii) being rude.

                    K Offline
                    K Offline
                    Krishhhhhhhhhhhhhh
                    wrote on last edited by
                    #9

                    I won't excuse u people for i) irresponsible ii) For not answering my questions iii) wasting my time

                    B A A 4 Replies Last reply
                    0
                    • K Krishhhhhhhhhhhhhh

                      I won't excuse u people for i) irresponsible ii) For not answering my questions iii) wasting my time

                      B Offline
                      B Offline
                      Bassam Saoud
                      wrote on last edited by
                      #10

                      He is right that you are cross posting (bad boy!)and you are right that he found the time to mention that you are crossposting but cant find the time to answer the question:)

                      1 Reply Last reply
                      0
                      • K Krishhhhhhhhhhhhhh

                        I won't excuse u people for i) irresponsible ii) For not answering my questions iii) wasting my time

                        B Offline
                        B Offline
                        Bassam Saoud
                        wrote on last edited by
                        #11

                        I answerd your question:)

                        1 Reply Last reply
                        0
                        • K Krishhhhhhhhhhhhhh

                          I won't excuse u people for i) irresponsible ii) For not answering my questions iii) wasting my time

                          A Offline
                          A Offline
                          Ashfield
                          wrote on last edited by
                          #12

                          Krishhhhhhhhhhhhhh wrote:

                          i) irresponsible

                          In what way?

                          Krishhhhhhhhhhhhhh wrote:

                          ii) For not answering my questions

                          It has been aswered. Also remember that nobody here is paid to answer questions, they do so out of kindness

                          Krishhhhhhhhhhhhhh wrote:

                          ) wasting my time

                          Well don't bother posting any more questions, particularly when you are so rude.

                          Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

                          1 Reply Last reply
                          0
                          • K Krishhhhhhhhhhhhhh

                            I won't excuse u people for i) irresponsible ii) For not answering my questions iii) wasting my time

                            A Offline
                            A Offline
                            Abhijit Jana
                            wrote on last edited by
                            #13

                            Hi, Please don't be rude. Here every one try to help each other. So be polite while asking question or seeking for help. Thanks !

                            Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

                            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