Database

 SELECT ID, time, type, ((first + last) * 0.5) AS avg10, 
(	CASE WHEN (a.ID+1) % 5 = 0 THEN 
		(
			SELECT ((c.first + c.last) * 0.5) FROM a, tmp_ak000002_50 c WHERE c.ID = (a.ID + 1) / 5 - 1) 
	WHEN a.ID = (SELECT MAX(a.ID) FROM a) AND (a.ID + 1) % 5 != 0 THEN
		(
			SELECT ((c.first + c.last) * 0.5) FROM a, tmp_ak000002_50 c WHERE c.ID = (a.ID + 1 + 4) / 5 - 1) 
	ELSE NULL END) AS avg50
INTO NewTable
FROM tmp_ak000002_10 a

<br />
cmdInsert.Parameters.AddWithValue("@RECORD_DATE", DateTime.Today);

<br />
CultureInfo ci = new CultureInfo("en-US");<br />
DateTime begin = DateTime.Parse(txtDate1.Text, ci);<br />
DateTime end = DateTime.Parse(txtDate2.Text, ci);<br />

cmd.CommandText = "SELECT KODU,CDISMI,CDTURU,CDADET,ACIKLAMA FROM TBL_PS_2" +<br />
" WHERE RECORD_DATE BETWEEN '" + txtDate1.Text + "' AND '" + txtDate2.Text + "' ";<br />

CREATE FUNCTION [dbo].[Split](@data NVARCHAR(MAX), @delimiter NVARCHAR(5))
RETURNS @t TABLE (data NVARCHAR(max))
AS
BEGIN
    
    DECLARE @textXML XML;
    SELECT    @textXML = CAST('<d>' + REPLACE(@data, @delimiter, '</d><d>') + '</d>' AS XML);

    INSERT INTO @t(data)
    SELECT  T.split.value('.', 'nvarchar(max)') AS data
    FROM    @textXML.nodes('/d') T(split)
    
    RETURN
END

CREATE FUNCTION [dbo].[Split](@data NVARCHAR(MAX), @delimiter NVARCHAR(5))<br />
RETURNS @t TABLE (data NVARCHAR(max))<br />
AS<br />
BEGIN<br />
    <br />
    DECLARE @textXML XML;<br />
    SELECT    @textXML = CAST('<d>' + REPLACE(@data, @delimiter, '</d><d>') + '</d>' AS XML);<br />
<br />
    INSERT INTO @t(data)<br />
    SELECT  T.split.value('.', 'nvarchar(max)') AS data<br />
    FROM    @textXML.nodes('/d') T(split)<br />
    <br />
    RETURN<br />
END<br />
<br />