We help IT Professionals succeed at work.
Get Started

Cursor SQL 2012

steven
steven asked
on
81 Views
Last Modified: 2015-12-11
We are currently load data to tables from a spread sheet.  The first table to load the "master"  is a one to many relationship.  To start we have a cursor that grabs the items to load.  IT then loads the master table inside of that cursor is another that pulls the many columns to populate using the ITEM from the outside cursor.  The inside cursor only runs one time and exits?  We pass it the item value from the outter cursor, the inside cursor pulls 8 values, for the ONE item value, but it will only load the first pass and exit.  

I am not real good with sql, so why doesn't it run the full eight times and then exit.  (Some will have as little as five runs)
BomInsert.sql
Comment
Watch Question
Business Intelligence Developer and Analyst
CERTIFIED EXPERT
Top Expert 2015
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE