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!

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

Recent content by cam10

  1. cam10

    How to take a single record and split it into 2 equal valued records.

    Thanks, this is more or less what I ended up doing. 1. I created a temp table 2. Inserted the values of the multiple select query into the temp table. 3. Updated the value of the record in question (in the temp table) and divided by 2 4. Inserted a second record based on 3 above. Thanks...
  2. cam10

    How to take a single record and split it into 2 equal valued records.

    In a stored procedure (with many nested select statements) I am trying to split one particular record into 2 equal records with equal values. So, for example, if I come across a record with a description of "dog" and it has an associated numeric value of 30, I want to split it into 2 records...

Part and Inventory Search

Back
Top