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. The Lounge
  3. UPDATE Members SET Rep = Rep + 1000 WHERE Mvp = 1

UPDATE Members SET Rep = Rep + 1000 WHERE Mvp = 1

Scheduled Pinned Locked Moved The Lounge
htmldatabasearchitectureannouncement
8 Posts 8 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.
  • A Offline
    A Offline
    AspDotNetDev
    wrote on last edited by
    #1

    To all the MVP's out there, looks like the participant reputation points have finally been increased by 1,000. That makes me gold. Another 400 or so and I'll be platinum. :cool: And on a side note, it would be nice if SQL had a += operator.

    [WikiLeaks Cablegate Cables]

    OriginalGriffO C L R P 6 Replies Last reply
    0
    • A AspDotNetDev

      To all the MVP's out there, looks like the participant reputation points have finally been increased by 1,000. That makes me gold. Another 400 or so and I'll be platinum. :cool: And on a side note, it would be nice if SQL had a += operator.

      [WikiLeaks Cablegate Cables]

      OriginalGriffO Offline
      OriginalGriffO Offline
      OriginalGriff
      wrote on last edited by
      #2

      Whooo! So it has - that makes me Gold as well, I thought I would need the rest of this year to get there!

      Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

      "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
      "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

      1 Reply Last reply
      0
      • A AspDotNetDev

        To all the MVP's out there, looks like the participant reputation points have finally been increased by 1,000. That makes me gold. Another 400 or so and I'll be platinum. :cool: And on a side note, it would be nice if SQL had a += operator.

        [WikiLeaks Cablegate Cables]

        C Offline
        C Offline
        Chris Meech
        wrote on last edited by
        #3

        aspdotnetdev wrote:

        if SQL had a += operator

        I think it may depend upon what/whose SQL you are using. IANAE, but I think PostgreSQL may support what you are looking for. See here[^]. :)

        Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

        1 Reply Last reply
        0
        • A AspDotNetDev

          To all the MVP's out there, looks like the participant reputation points have finally been increased by 1,000. That makes me gold. Another 400 or so and I'll be platinum. :cool: And on a side note, it would be nice if SQL had a += operator.

          [WikiLeaks Cablegate Cables]

          L Offline
          L Offline
          leppie
          wrote on last edited by
          #4

          aspdotnetdev wrote:

          And on a side note, it would be nice if SQL had a += operator.

          On an extra side dish, how about a ++ operator? :)

          ((λ (x) `(,x ',x)) '(λ (x) `(,x ',x)))

          1 Reply Last reply
          0
          • A AspDotNetDev

            To all the MVP's out there, looks like the participant reputation points have finally been increased by 1,000. That makes me gold. Another 400 or so and I'll be platinum. :cool: And on a side note, it would be nice if SQL had a += operator.

            [WikiLeaks Cablegate Cables]

            R Offline
            R Offline
            Roger Wright
            wrote on last edited by
            #5

            As points go, the Participant category is the least credible. The score there is entirely arbitrary and meaningless, as mine hasn't moved since it's inception and represents less than 10% of what it actually should display. Either that, or the description is wrong. Maybe it should say a point is earned for each 1000 comments posted, or 200 surveys answered.

            Will Rogers never met me.

            S 1 Reply Last reply
            0
            • R Roger Wright

              As points go, the Participant category is the least credible. The score there is entirely arbitrary and meaningless, as mine hasn't moved since it's inception and represents less than 10% of what it actually should display. Either that, or the description is wrong. Maybe it should say a point is earned for each 1000 comments posted, or 200 surveys answered.

              Will Rogers never met me.

              S Offline
              S Offline
              Sandeep Mewara
              wrote on last edited by
              #6

              Roger Wright wrote:

              represents less than 10% of what it actually should display

              As much I know, based on the FAQ, Participant points are calculated from year 2009. Since then logins, winners, comments and surveys are awarded as said. Apart from that, sign-up 100 is by default added to everyone irrespective of joining year. Any news-letter feed if opted, and any competition winning - whenever it be, should be awarded and accounted for. Thus, SignUp points + news-letter + Competition winning + Sign-in since 2009 + comments in Q&A made - should sum up to current 'Participant' rep-score.

              Sandeep Mewara [My latest tip/trick] [Forum guidelines]

              1 Reply Last reply
              0
              • A AspDotNetDev

                To all the MVP's out there, looks like the participant reputation points have finally been increased by 1,000. That makes me gold. Another 400 or so and I'll be platinum. :cool: And on a side note, it would be nice if SQL had a += operator.

                [WikiLeaks Cablegate Cables]

                P Offline
                P Offline
                Pranay Rana
                wrote on last edited by
                #7

                yepppppppeeeeeeeeeeeeeee Congs. for the mvp award

                For any question : http://pranayamr.blogspot.com/ Do vote my articles Best C# article of December 2010
                Best ASP.NET article of December 2010
                Best overall article of December 2010

                1 Reply Last reply
                0
                • A AspDotNetDev

                  To all the MVP's out there, looks like the participant reputation points have finally been increased by 1,000. That makes me gold. Another 400 or so and I'll be platinum. :cool: And on a side note, it would be nice if SQL had a += operator.

                  [WikiLeaks Cablegate Cables]

                  P Offline
                  P Offline
                  PIEBALDconsult
                  wrote on last edited by
                  #8

                  I didn't get MVP until I was already platinum. They must have lowered the standards again. :-D I thought the they had corrected last year's error.

                  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