April 14, 2014 at 10:15 pm
Comments posted to this topic are about the item Decryption Keys
April 14, 2014 at 11:59 pm
Nice question, made me do some research.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 15, 2014 at 1:18 am
good question Steve. Thanks for sharing
April 15, 2014 at 2:51 am
This was removed by the editor as SPAM
April 15, 2014 at 5:39 am
There were some missing pieces to the puzzle that made it more interesting. I was forced to question if the key was supposed to be there and if the SaleValue referred to in the question as the "last column" was supposed to be "Sales" or was a mistake. When I really thought it through, it was clear, consistent and unambiguous. Thanks, Steve, for a good question to wake up my brain this morning.
April 15, 2014 at 6:51 am
Had to flip a coin between first and second answer. The question just asks for what will decrypt the field - the first one does do this, it just returns the values in a slightly less usable format.
April 15, 2014 at 7:03 am
Very good question. Thank you!
April 15, 2014 at 7:58 am
Good question, Steve. It made me do some research, since I haven't used encryption yet professionally. I did notice a few minor errors: the field name should have been Sales, not SalesValue, and the third and fourth options appear to be missing a comma, so they probably wouldn't pass the parser, even if there was a function by that name. However, these are minor quibbles that don't really detract from a good question. Thanks! 🙂
April 15, 2014 at 9:25 am
stephen.long 56048 (4/15/2014)
Good question, Steve. It made me do some research, since I haven't used encryption yet professionally. I did notice a few minor errors: the field name should have been Sales, not SalesValue, and the third and fourth options appear to be missing a comma, so they probably wouldn't pass the parser, even if there was a function by that name. However, these are minor quibbles that don't really detract from a good question. Thanks! 🙂
+1 Enjoyed the question. Don't use encryption currently, so nice to learn something new.
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn
April 16, 2014 at 1:45 am
stephen.long 56048 (4/15/2014)
Good question, Steve. It made me do some research, since I haven't used encryption yet professionally.
+1
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
April 16, 2014 at 2:09 pm
Hany Helmy (4/16/2014)
stephen.long 56048 (4/15/2014)
Good question, Steve. It made me do some research, since I haven't used encryption yet professionally.+1
+1 more
April 16, 2014 at 10:01 pm
Koen Verbeeck (4/14/2014)
Nice question, made me do some research.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
April 28, 2014 at 6:52 am
nice question Steve.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply