Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

SSN's

Discussion in 'Information Technology' started by ChrisBruell, Jul 28, 2006.

Tags:
  1. ChrisBruell

    ChrisBruell
    Expand Collapse
    Guest

    I am in the process of setting up a student DB. I have a table setup with
    student info linked to another table of grades by SSN. when I run a query
    simply trying to combine the two tables, I am only getting those SSN's that
    begin with 0. any ideas why?
     
  2. xRoachx

    xRoachx
    Expand Collapse
    Guest

    Hi Chris -- Post your SQL for the query.

    "ChrisBruell" wrote:

    > I am in the process of setting up a student DB. I have a table setup with
    > student info linked to another table of grades by SSN. when I run a query
    > simply trying to combine the two tables, I am only getting those SSN's that
    > begin with 0. any ideas why?
     
  3. fredg

    fredg
    Expand Collapse
    Guest

    On Tue, 27 Jun 2006 14:01:02 -0700, ChrisBruell wrote:

    > I am in the process of setting up a student DB. I have a table setup with
    > student info linked to another table of grades by SSN. when I run a query
    > simply trying to combine the two tables, I am only getting those SSN's that
    > begin with 0. any ideas why?


    At the very least, it would be nice to see the actual query SQL.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Paul Overway

    Paul Overway
    Expand Collapse
    Guest

    Northeastern should have a better privacy policy. Using SSNs for this
    purpose is asking for trouble.

    --
    Paul Overway
    Logico Solutions, LLC
    www.logico-solutions.com


    "ChrisBruell" <ChrisBruell@discussions.microsoft.com> wrote in message
    news:F991C125-3BCA-4F0D-9881-E29055CD0DFE@microsoft.com...
    >I am in the process of setting up a student DB. I have a table setup with
    > student info linked to another table of grades by SSN. when I run a query
    > simply trying to combine the two tables, I am only getting those SSN's
    > that
    > begin with 0. any ideas why?
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 27 Jun 2006 14:01:02 -0700, ChrisBruell
    <ChrisBruell@discussions.microsoft.com> wrote:

    >I am in the process of setting up a student DB. I have a table setup with
    >student info linked to another table of grades by SSN. when I run a query
    >simply trying to combine the two tables, I am only getting those SSN's that
    >begin with 0. any ideas why?


    Other than the well-known legal, ethical, and practical problems of
    using SSN as an identifier for other than Federal government Social
    Security transactions...

    it sounds like maybe you're storing this value in a Number field. It
    should be Text.


    John W. Vinson[MVP]
     
  6. ChrisBruell

    ChrisBruell
    Expand Collapse
    Guest

    thanks for everyone's help. very helpful and our policy is to use 9-digit
    numbers, not SSN's. does that help anyone explain anything to me? okay,
    thanks

    "John Vinson" wrote:

    > On Tue, 27 Jun 2006 14:01:02 -0700, ChrisBruell
    > <ChrisBruell@discussions.microsoft.com> wrote:
    >
    > >I am in the process of setting up a student DB. I have a table setup with
    > >student info linked to another table of grades by SSN. when I run a query
    > >simply trying to combine the two tables, I am only getting those SSN's that
    > >begin with 0. any ideas why?

    >
    > Other than the well-known legal, ethical, and practical problems of
    > using SSN as an identifier for other than Federal government Social
    > Security transactions...
    >
    > it sounds like maybe you're storing this value in a Number field. It
    > should be Text.
    >
    >
    > John W. Vinson[MVP]
    >
     
  7. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 27 Jun 2006 20:29:02 -0700, ChrisBruell
    <ChrisBruell@discussions.microsoft.com> wrote:

    >thanks for everyone's help. very helpful and our policy is to use 9-digit
    >numbers, not SSN's. does that help anyone explain anything to me? okay,
    >thanks


    No.

    As requested, please post the SQL of the query and an example of the
    pseudo-SSN that's not being found.

    John W. Vinson[MVP]
     
  8. Ken Mitchell

    Ken Mitchell
    Expand Collapse
    Guest

    Hi, Chris. First, let me echo Fred, John, Paul and Roach in saying that SSN
    is a bad choice for a unique ID.

    Second, just because the StudentID contains only numerals, that doesn't
    mean it should be a number. Only use "Number" data types when you plan to use
    them in some numerical calculation such as adding, subracting, or
    multiplying. For other purposes, make them "text" fields; if they need to
    have a certain format, you can use Input Masks for the purpose.

    "ChrisBruell" wrote:

    > thanks for everyone's help. very helpful and our policy is to use 9-digit
    > numbers, not SSN's. does that help anyone explain anything to me? okay,
    > thanks
    >
    > "John Vinson" wrote:
    >
    > > On Tue, 27 Jun 2006 14:01:02 -0700, ChrisBruell
    > > <ChrisBruell@discussions.microsoft.com> wrote:
    > >
    > > >I am in the process of setting up a student DB. I have a table setup with
    > > >student info linked to another table of grades by SSN. when I run a query
    > > >simply trying to combine the two tables, I am only getting those SSN's that
    > > >begin with 0. any ideas why?

    > >
    > > Other than the well-known legal, ethical, and practical problems of
    > > using SSN as an identifier for other than Federal government Social
    > > Security transactions...
    > >
    > > it sounds like maybe you're storing this value in a Number field. It
    > > should be Text.
    > >
    > >
    > > John W. Vinson[MVP]
    > >
     

Share This Page