Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Decryption Keys Expand / Collapse
Author
Message
Posted Monday, April 14, 2014 10:15 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:38 PM
Points: 33,078, Visits: 15,190
Comments posted to this topic are about the item Decryption Keys






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1561736
Posted Monday, April 14, 2014 11:59 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:49 PM
Points: 13,283, Visits: 10,156
Nice question, made me do some research.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1561752
Posted Tuesday, April 15, 2014 1:18 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 5:56 AM
Points: 632, Visits: 1,152
good question Steve. Thanks for sharing
Post #1561765
Posted Tuesday, April 15, 2014 2:51 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:50 AM
Points: 3,859, Visits: 5,001
Had to really dig around for this.
Learned something new, thanks Steve


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1561781
Posted Tuesday, April 15, 2014 5:39 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:41 PM
Points: 3,960, Visits: 2,970
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.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1561814
Posted Tuesday, April 15, 2014 6:51 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:58 AM
Points: 1,208, Visits: 2,197
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.
Post #1561848
Posted Tuesday, April 15, 2014 7:03 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 1,554, Visits: 1,848
Very good question. Thank you!
Post #1561852
Posted Tuesday, April 15, 2014 7:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 9:23 AM
Points: 195, Visits: 132
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!
Post #1561881
Posted Tuesday, April 15, 2014 9:25 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:07 AM
Points: 1,765, Visits: 2,139
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.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1561939
Posted Wednesday, April 16, 2014 1:45 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:38 AM
Points: 1,139, Visits: 520
stephen.long 56048 (4/15/2014)
Good question, Steve. It made me do some research, since I haven't used encryption yet professionally.

+1
Post #1562158
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse