Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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]
    > >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page