I would definitely suggest you take JeffB's advice here.

I am also having some trouble figuring out your logic, but it seems like a few insert/update statements should be able to...

DECLARE SCHOOLNUM = @SCHOOLNUM2

OPEN SCHOOLNUM2_CURSOR

You use the variable '@SCHOOLNUM2' before you declare it, for starters.

Try fixing that, and then see what errors you get.

Finally got, had some issues with weird design, but your help got me where I needed to be.

Thanks All!

Two things I noticed when I started:

1. Install SP 3a for AS. You may as well go ahead and install SP 4 while you're at it, but most of...

I think this pretty much does it, but I'm still getting an error when I try to execute the SP. A little tweaking by someone should fix it.

CREATE PROCEDURE...

Thanks for the help Steve and Grasshopper.

Now that I've installed 2005, any new suggestions, or should I just bite the bullet and start playing with new design options?

Thanks and TIA,

Chris

"If ALL of these columns are NULL, i then want to remove the entry."

Do you want to remove columns where all columns are null, or just 5 out of 10...

Have you tried creating a dimension based on the the Loan ID?

Don't know for sure if it will work, but it may be best just to re-structure the view so...