ASP.NET

CREATE FUNCTION [dbo].[fnSplit](@sText varchar(max), @sDelim varchar(20) = ' ')
RETURNS @retArray TABLE (idx smallint IDENTITY(1,1) Primary Key, value varchar(max))
AS
BEGIN
	DECLARE 
		@value varchar(8000),
		@bcontinue bit,
		@iStrike smallint,
		@iDelimlength tinyint
	IF @sDelim = 'Space'
		BEGIN
		SET @sDelim = ' '
		END
	SET @sText = LTrim(RTrim(@sText))
	SET @iDelimlength = DATALENGTH(@sDelim)
	SET @bcontinue = 1
	IF NOT ((@iDelimlength = 0) or (@sDelim = 'Empty'))
		BEGIN
		WHILE @bcontinue = 1 BEGIN
	--If you can find the delimiter in the text, retrieve the first element and
	--insert it with its index into the return table.
	 
			IF CHARINDEX(@sDelim, @sText)>0 BEGIN
				SET @value = SUBSTRING(@sText,1, CHARINDEX(@sDelim,@sText)-1)
				INSERT @retArray(value) VALUES (@value)
				
				--Trim the element and its delimiter from the front of the string.
				--Increment the index and loop.
				SET @iStrike = DATALENGTH(@value) + @iDelimlength
				SET @sText = LTrim(Right(@sText,DATALENGTH(@sText) - @iStrike))
			END ELSE BEGIN
				--If you can't find the delimiter in the text, @sText is the last value in
				--@retArray.
				SET @value = @sText
				INSERT @retArray (value) VALUES (@value)
				--Exit the WHILE loop.
				SET @bcontinue = 0
			END
		END
	END ELSE BEGIN
		WHILE @bcontinue=1 BEGIN
			--If the delimiter is an empty string, check for remaining text
			--instead of a delimiter. Insert the first character into the
			--retArray table. Trim the character from the front of the string.
			--Increment the index and loop.
			IF DATALENGTH(@sText)>1 BEGIN
				SET @value = SUBSTRING(@sText,1,1)
				INSERT @retArray (value) VALUES (@value)
				SET @sText = SUBSTRING(@sText,2,DATALENGTH(@sText)-1)
			END ELSE BEGIN
				--One character remains.
				--Insert the character, and exit the WHILE loop.
				INSERT @retArray (value) VALUES (@sText)
				SET @bcontinue = 0	
			END
		END
	END
	RETURN
END

SELECT * FROM [Operation] o
  join fnsplit( @terminals, ',') t on o.Terminal = t.value
WHERE [Ack] = @Ack AND [AckFlag] = @AckFlag

abglorie wrote:

Note that: some times I want sum from field(4) to field(6) into field(7)

santoshkumarB wrote:

So can any one help me to write this VB code in C#.