SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Personal Checksum


The Personal Checksum

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63050 Visits: 19113
Comments posted to this topic are about the item The Personal Checksum

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Julie Breutzmann
Julie Breutzmann
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1275 Visits: 1921
It's been suggested that one can give a bogus middle initial as a way of tracking whether or not someone keeps your information private or sells it. So one might give their name as Steve S Jones to SQL Server Central (with S being a simple reminder it was given to SQL Server Central). Then if you are contact by someone else as Steve S Jones, you have strong reason to suspect that your information was shared/sold.
Will1922
Will1922
SSC Eights!
SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)

Group: General Forum Members
Points: 951 Visits: 481
Ok, I've got a minor in math and I don't understand what the significance of the graphic is. A, B and C have no real reference to each other.

If I change the subtotal to 42.32, add 10% (dropping the cents) 4.20 you get 46.52. 4 + 6 = 2? No.

What am I missing here?


Live to Throw
Throw to Live
Will Summers
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63050 Visits: 19113
Will,

The idea is that you decide on the tip dollar amount. So you decide that with bad service, you're leaving $4 on $47. So you write the $51 (47 + 4). Then you add those up(51 being 5 + 1) to get 6. You write in 6 for the end cents amount and then do the math to figure out the proper cents amount for the tip.

The middle name thing is interesting, though I'm not sure how well that would work. Data quality seems to be suspect and I've gotten quite a few middle initials come through with my name over the years.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Will1922
Will1922
SSC Eights!
SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)

Group: General Forum Members
Points: 951 Visits: 481
Wow, that's way way too much energy to put in to calculate a tip for bad service. I would just do something like not leave a tip and write in BAD SERVICE in the tip line.

I will tip 20%+ if I have no complaints about the service. If I have to wait more than a couple of minutes for the server to recognize that my drink is empty, then that 20% drops pretty quickly.


Live to Throw
Throw to Live
Will Summers
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63050 Visits: 19113
It is a little confusing. I tried it the other day and confused myself.

Keep in mind that I've seen some people change good tips (rarely) when it seems to work out. Adding a few dollars might happen on top of your 20%.

Not really my style either, but I thought it was an intersting use of data checksums. I think if you tried it 5 times, it would come pretty naturally.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
jay-h
jay-h
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1913 Visits: 2337
A co worker was called by a restaurant because he had accidently put $50 in the tip spot. They suspected this was an error.

When I get really good service, I tip CASH even if I charge the meal. I let them decide how to handle it.

...

-- FORTRAN manual for Xerox Computers --
Wayne West
Wayne West
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2652 Visits: 3702
What we need are checksums on personal identification numbers, such as SSNs and driver's licenses (which may already have them). I understand the Canadian equivalent of SSN is already checksummed. That might have helped against the identity theft problems that are plaguing us.

At least our credit card numbers are checksummed, for what little good that does us. I'd like to see ecommerce PIN all credit card transactions in addition to the CVN, I think that would really cut down on online fraud and eliminate most of the bottom feeder/script kiddie fraudsters.

As far as the middle initial thing is concerned, an easier method is to do variations on your address. If you live in apartment 123, when you subscribe to Byte, make your apartment number 123B. Or add suites if you're a plain old street address. That will tell you exactly who is selling your info.

Another thing that I do is if some form requires my phone number, I give them 575-555-5555. Seems to work every time.

-----
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson
Will1922
Will1922
SSC Eights!
SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)SSC Eights! (951 reputation)

Group: General Forum Members
Points: 951 Visits: 481
The purpose of the article wasn't to decide on tip amounts, but to give you a checksum for the credit card statement. On all restaurant charges on the bill the sum of the first two digits should equal the last digit. This would be a good way to test for theft.

It helps when you actually read the article fully before posting a question about it. ha ha. My bad.


Live to Throw
Throw to Live
Will Summers
mbrownfield
mbrownfield
Valued Member
Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)

Group: General Forum Members
Points: 52 Visits: 179
The webpage mentioned in the article contained a link to "Surf hundreds of visa numbers". Kinda ironic, huh? Weren't we trying to detect fraud here?



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search