hi,

i am using below to save data to my db ( creating text boxes dynamically using SP and saving values to string. using split string function to split comma separated valuesand insert into db)

BEGIN
	set @varvaltime= sysdatetime()
	SET @sDate=(SELECT REPLACE(@sDate,'"',''))

if ( not exists( select Shp_summary_Id from TRAN_SHIPMENT_SUMMARY where SailDate = @sDate and Vessel_Id= @vesId ))
BEGIN
Insert into TRAN_SHIPMENT_SUMMARY (Analysis_Id,Vessel_Id,SailDate,Moist,Shp_QWmt,Shp_Qdmt) values (@intAnalysisId,@vesId,@sDate,@moisture,@qwmt,@qdmt)
END
	BEGIN
		insert into TRAN_SHIPMENT_VALUES (Value,Shp_Parameter_Id,SailDate,Vessel_Id,Analysis_Id,ValueTime ,Valuewith,Grade,Last_Updated_By,IsActive,IsDeleted,Shp_summary_Id)
		select Value.Value, Shp_Parameter_Id.Shp_Parameter_Id,@sDate SailDate , @vesId Vessel_Id ,@intAnalysisId Analysis_Id ,@varvaltime ValueTime,@valwith Valuewith,@grade Grade,@user Last_Updated_By,IsActive=1,IsDeleted=0,( select Shp_summary_Id from TRAN_SHIPMENT_SUMMARY where SailDate = @sDate and Vessel_Id= @vesId) Shp_summary_Id
		from (SELECT  ROW_NUMBER() OVER (ORDER BY (SELECT 0)) RowNo,TRY_CONVERT(decimal(8,3),Item) Value FROM dbo.SplitString(@shpVals, ',')  ) Value,
			 (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0)) RowNo,TRY_CONVERT(int,Item) Shp_Parameter_Id FROM dbo.SplitString( @paramId, ',') ) Shp_Parameter_Id 
		where  Shp_Parameter_Id.RowNo=Value.RowNo				
	END			 		
END	

how can i write an update query for updating record for respective analysis 

i tried below 

BEGIN
		Update TRAN_SHIPMENT_VALUES set Value=(SELECT  ROW_NUMBER() OVER (ORDER BY (SELECT 0)) RowNo,TRY_CONVERT(decimal(8,3),Item) Value FROM dbo.SplitString(@shpVals, ',')  ) , 
				Shp_Parameter_Id= (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0)) RowNo,TRY_CONVERT(int,Item) Shp_Parameter_Id FROM dbo.SplitString( @paramId, ',') ),
				SailDate=@sDate,Vessel_Id=@vesId,Analysis_Id=@intAnalysisId,ValueTime=@varvaltime,Valuewith=@valwith,Grade=@grade,Last_Updated_By=@user,IsActive=1,IsDeleted=0
				where SailDate = @sDate and Vessel_Id= @vesId and Valuewith=@valwith and Analysis_Id=@intAnalysisId
		END