Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jrock2468

    INSERT doable in SQL?

    -- The repeating refPersonGroupId violate First Normal Form Ok, I oversimplified what I'm actually dealing with because my ability to draw clear ascii art is limited to two tables. In reality, refPersonGroupId1 and refPersonGroupId2 don't point to the same table. They point to two different...
  2. jrock2468

    INSERT doable in SQL?

    Actually error is 'number of query values and destination fields are not the same'
  3. jrock2468

    INSERT doable in SQL?

    PHV and Gomom - I read PHV's link... are you saying that this won't work? I'm trying to simplify what I'm really doing into something that's easy to post and comment on. In reality there are two fields that are references to the primary key of another table that need to be updated (hopefully...
  4. jrock2468

    INSERT doable in SQL?

    PHV - One more quick addition to the last addition. Your query works great. Now, if I need to add on additional groups, like refPersonGroupId1, refPersonGroupId2, refPersonGroupId3... how would I extend your query? I tried this, but it didn't work: INSERT INTO tblPerson (PersonFirstName...
  5. jrock2468

    INSERT doable in SQL?

    You rock it like a hurricane =)
  6. jrock2468

    INSERT doable in SQL?

    Is this doable with one SQL query? There are two tables: tblPerson ---------------- PersonId PersonFirstName PersonLastName -> refPersonGroupId | | | (linked by) | | | tblPersonGroup | ---------------- -> PersonGroupId PersonGroupName So...

Part and Inventory Search

Back
Top