Dividing one field into many and adding them

[checkai]

Example field = 4;4;3;65;43;813;345

I have a variable ex; 3

I want 2 things, the 3rd value alone (3) and
the addition up to 3rd value (4+4+3)

Thanks,

Dustin

 

[Vinodk]

Declare @field varchar(50), @loc int
Set @field = '4;4;3;65;43;813;345'
Set @loc = 3
CREATE TABLE #temp (PkID Int Identity, Id INT NOT NULL)
declare @param VARCHAR(8000)
Set @param = REPLACE(@field, ';', ' UNION SELECT ')
Select @param
INSERT #temp EXEC ('SELECT ' + @param)
SELECT * FROM #temp Where pkid = @loc
Select Sum(ID) from #temp where pkid <=@loc
Drop table #Temp

HTH,
Vinod Kumar