จะ query ข้อมูลเปรียบเทียบระหว่างวันที่ส่งล่าสุด กับ วันนี้ ออกมาเป็นจำนวนวัน แล้วเอาไปโชว์ใน คอลัมได้มั้ยครับ

SELECT A.[Resu_ID]
      ,A.[Rese_ID]
      ,A.[Resu_Date]
  FROM [Cust].[dbo].[T_Results] A , [Cust].[dbo].[T_Reservations] B
WHERE A.Rese_ID = B.Rese_ID

SELECT s.[Resu_ID], s.[Rese_ID], s.Resu_Date,  (SELECT DATEDIFF(day,s.[Resu_Date],GETDATE())) as Status, s.Resu_Send_Total, s.Resu_Pending
FROM [Cust].[dbo].[T_Reservations] r 
LEFT JOIN [Cust].[dbo].[T_Results] s ON r.Rese_ID = s.Rese_ID
AND s.Resu_ID=(SELECT TOP 1 x.Resu_ID FROM [Cust].[dbo].[T_Results] x
WHERE x.Rese_ID = r.Rese_ID
ORDER BY x.Resu_Date DESC)

,case when[T_ANS] is null then '0' ";
          else [T_ANS] end as [T_ANS]";

ss = "select max (Resu_ID) from T_Results where Rese_ID = '" + RequestID + "'";
									SqlCommand cmdss = new SqlCommand(ss, db);
									SqlDataAdapter dass = new SqlDataAdapter(cmdss);
									DataSet dsss = new DataSet();
									dass.Fill(dsss, "Cust");

									Object bs = cmdss.ExecuteScalar();

									sqls = "SELECT DATEDIFF(day,[Resu_Date],GETDATE()) As DiffDate FROM [T_Results] where Rese_ID = '" + RequestID + "' and Resu_ID = '" + bs + "'";

									SqlCommand cmdd = new SqlCommand(sqls, db);
									SqlDataAdapter dad = new SqlDataAdapter(cmdd);
									DataSet dsd = new DataSet();
									dad.Fill(dsd, "Cusst");

									Object ad = cmdd.ExecuteScalar();

									int aad = Convert.ToInt32(ad.ToString());

									StringBuilder sb = new StringBuilder();

									sb.AppendLine(" UPDATE [Cust].[dbo].[T_Reservations] ");
									//sb.AppendLine("    SET [Cust_ID] = @Cust_ID ");
									//sb.AppendLine("       ,[Fab_ID] = @Fab_ID ");
									//sb.AppendLine("       ,[Rese_Date] = @Rese_Date ");
									//sb.AppendLine("       ,[Rese_Amount] = @Rese_Amount ");
									//sb.AppendLine("       ,[Rese_Price] = @Rese_Price> ");
									sb.AppendLine("      SET [Resu_Send_Total] = @Resu_Send_Total ");
									sb.AppendLine("       ,[Resu_Pending] = @Resu_Pending ");
									sb.AppendLine("       ,[Rese_Status] = @Rese_Status ");
									sb.AppendLine("  WHERE Rese_ID = '" + RequestID + "'");
									
									SqlCommand cmds = new SqlCommand(sb.ToString(), db);
									cmds.Parameters.AddWithValue("@Resu_Send_Total", data);
									cmds.Parameters.AddWithValue("@Resu_Pending", pending);
									if (pending <= 0) {
										cmds.Parameters.AddWithValue("@Rese_Status", "ส่งครบแล้ว");
									}
									else {
										cmds.Parameters.AddWithValue("@Rese_Status", aad + " วัน");
									}