how to read and manipulate more than one line of data in a tvp

Can you post some sample records and the desired output result set so that it would be helpful to understand your requirement better..

 Okay, I have all of the data passing correctly - i think!
the image is the sample data i am working with

the SP is to compare two investment scenarios based on this
 
Plan-1: Giving compound interests to all savings account holders.  
Plan-2:  Increase all savings account interest rates by 2%.  
Plan-3:  Increase all fixed account interest rates by 2%.  
Plan-4: Giving 5% bonus per year for all fixed account holders.  

Here is the code - at this point I am more concerned about my math (again I think) as I have been looking at this so long my eyes are crossing!

USE [Unit11]
GO

/****** Object:  StoredProcedure [dbo].[InvestmentPlans]    Script Date: 04/01/2010 18:58:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[InvestmentPlans]
(@invest as bestScenario READONLY )
AS
DECLARE @CustId Char(4) -- customer ID
DECLARE @R FLOAT  -- rate of interst
DECLARE @N INT  -- number of years 
DECLARE @P FLOAT  --Prinicipal amount
DECLARE @NP Float --New Principal amount
DECLARE @F Float -- Final Amount 
DECLARE @Cplan FLOAT  -- Current plan final amount 
DECLARE @Nplan1 FLOAT  -- proposed plan1  final amount
DECLARE @Nplan2 FLOAT -- proposed plan2 final amount
DECLARE @Nplan3 FLOAT -- proposed plan3 final amount
DECLARE @Nplan4 FLOAT -- proposed plan4 final amount
Declare @deptype char(6) -- deposit type
DECLARE @D1 Float --difference between current plan1 and new plan1
DECLARE @D2 Float --difference between current plan2 and new plan2
DECLARE @D3 Float --difference between current plan3 and new plan3
DECLARE @D4 Float --difference between current plan4 and new plan4

-- Declare cursor 
Declare custCursor CURSOR 
local Scroll Keyset Optimistic


FOR SELECT CustID, DepositType,NumberOfYears,Rate,PrincipalAmount
FROM @invest
SET @Nplan1 = 0
SET @Nplan2 = 0
SET @Nplan3 = 0
SET @Nplan4 = 0
SELECT @Cplan = SUM(FinalAmount)FROM @invest

OPEN custCursor

FETCH Next FROM custCursor INTO @custid,@deptype, @N, @R,@P

While @@FETCH_STATUS =0 

BEGIN

-- calculate compound interest for saving customers::plan 1 
BEGIN
	--SELECT @Cplan = SUM(FinalAmount)FROM @invest
	IF @deptype = 'saving'
	SET @NP =  @P * (Power (@N,(1 + @R)))
	ELSE IF @deptype = 'fixed'
	SET @NP = @P
	SET @Nplan1= @Nplan1 +@NP
	SET @D1 = ((@Nplan1-@Cplan)/@Cplan)*100
END

-- check for saving customers for plan 2
BEGIN
	IF @deptype = 'saving'
	SET @NP = @P + (@P * @N * (@R +.02))
	ELSE IF @deptype = 'fixed'
	SET @NP = @P 
	SET @Nplan2= @Nplan2 +@NP
	SET @D2 = (((@Nplan2 - @Cplan)/@Cplan)*100)
END	

-- Increase R by 2 %  for fixed for  plan 3 
BEGIN
	IF @deptype = 'fixed'
	SET @NP = @P * @N * (@R +2)
	ELSE IF @deptype = 'saving'
	SET @NP = @NP
	SET @Nplan3= @Nplan3 +@P
	SET @D3 = (((@Nplan3 - @Cplan)/@Cplan)*100)
END   	

-- Calculate fixed plans with 5% bonus for plan 4
BEGIN
	IF @deptype = 'fixed'
	SET @NP= @P * (Power (@N,(1 + @R))) + (.05 *(( @P * (Power(@N,(1 + @R))))* @N))
	ELSE IF @deptype = 'saving'
	SET @NP = @P
	SET @Nplan4 = @Nplan4 +@NP
	SET @D4 = (((@Nplan4 - @Cplan)/@Cplan)*100)
END 

FETCH Next FROM custCursor INTO @custid,@deptype, @N, @R,@P	
END

CLOSE custCursor
DEALLOCATE custCursor


BEGIN
PRINT @Cplan
PRINT @Nplan1
PRINT @D1

IF @D1 < 10
BEGIN
	PRINT 'Plan 1 is suitable' 
END

ELSE IF @D1 > 10
BEGIN
	PRINT 'Plan 1 is not suitable,the difference is'
	PRINT @D1
	PRINT '%'
END
END

 --compare proposed vs  current for > 10% rule  for  plan 2
BEGIN
	PRINT '_________________________________________________________'
	PRINT @Cplan
	PRINT @Nplan2
	PRINT @D2
	
IF @D2 < 10
BEGIN
   	PRINT 'Plan 2 suitable' 
END 
ELSE IF @D2 > 10 
BEGIN
	PRINT 'Plan 2 is not suitable,the difference is'
	PRINT @D2
	PRINT '%' 
END
END	

 -- compare proposed vs  plan for  plan 3 
BEGIN
	PRINT '_________________________________________________________'
	PRINT @Cplan
	PRINT @Nplan3
	PRINT @D3
	
IF @D3 < 10
BEGIN
   	PRINT 'Plan 3 suitable' 
END
ELSE IF @D3 > 10
BEGIN
		PRINT 'Plan 3 is not suitable,the difference is'
		PRINT @D3
		PRINT '%' 
END	

-- compare proposed vs  current for >10%  for  plan 4
BEGIN
	PRINT '_________________________________________________________'
	PRINT @Cplan
	PRINT @Nplan4
	PRINT @D4
	
IF @D4 < 10
BEGIN
   	PRINT 'Plan 4 suitable' 
END
ELSE IF @D4 > 10
BEGIN
		PRINT 'Plan 4 is not suitable,the difference is'
		PRINT @D4
		PRINT '%' 
 END
 END

SELECT *
FROM @invest
END

GO

Select allOpen in new window

sampledatatable.PNG

The data is read into a TVP, I am not sure the code to accomplish this across a column and the rates will vary for each person......The program works as it is.....I am just sure there has to be another way. I was told this could be done without using cursors but can not figure it out.

>> I was told this could be done without using cursors but can not figure it out.

Regret for the delay as it is a weekend..
And hope you sorted it out..