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

selecting all attributes for a loan from a loan table Expand / Collapse
Author
Message
Posted Tuesday, April 16, 2013 9:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 8:51 AM
Points: 6, Visits: 145
Hi all,
I have a student loan table that holds details such as the loan#, SSN and their dob(birth date).The table is more than 65000 rows in total.I am required to list the SSN and the dob of the students into a table and present it in the order Loan#, SSN and dob.
I am presented with only the loan number of 550 students out of this table.I have to find their SSN numbers and their dob using this list provided.
Any suggestions?
Post #1443077
Posted Tuesday, April 16, 2013 9:55 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 5:34 PM
Points: 35,609, Visits: 32,200
Joechelad (4/16/2013)
Hi all,
I have a student loan table that holds details such as the loan#, SSN and their dob(birth date).The table is more than 65000 rows in total.I am required to list the SSN and the dob of the students into a table and present it in the order Loan#, SSN and dob.
I am presented with only the loan number of 550 students out of this table.I have to find their SSN numbers and their dob using this list provided.
Any suggestions?


Yes. Tell the people that you're doing this for that they're breaking several privacy acts, SOX and SEC requirements, a couple of State laws, a Federal Law or two, and the laws of common sense by storing SSNs in plain text on an unencrypted disk. If they don't listen, you should sharpen up your resume, find another job, and blow the whistle on them before someone blows the whistle on you.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1443088
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse