yahyaahrika

--https://stackoverflow.com/questions/55249646/how-to-skip-rows-with-same-column-values-in-sql-server

CREATE TABLE T(
  Col1 INT,
  Col2 VARCHAR(45),
  Col3 VARCHAR(45)
);

INSERT INTO T VALUES
(1, 'Steve',  'Rodgers'),  

yahyaahrika

CREATE PROCEDURE "SP_Statistique_UmsatzbyTime"(
	@dateStart DATE,
	@dateFin DATE
)

AS
BEGIN

SELECT 
		 Concat(DATEPART(hh ,stardate ),':00')  AS Hours ,

yahyaahrika

CREATE PROCEDURE "SP_Statistique_Date"(
	@dateStart DATE,
	@dateFin DATE
)

AS
BEGIN


DROP TABLE IF EXISTS #tmp_umsatz , #tmp_google ,  #tmp_offen , #tmp_auftrage ;

yahyaahrika

CREATE PROCEDURE  "SP_Loop_Monteur_Gewinn"(
@StartDate Date,
@FinDate  Date
)
AS BEGIN

DECLARE @Counter INT
DECLARE @Lenght INT
DECLARE @CalculDateStart DATE

yahyaahrika

 $.fn.dataTable.ext.errMode = function (settings, helpPage, message) {
           if (settings.iDrawError == -1) {
               document.location.reload();
           }
       };

yahyaahrika

root@localhost:~# sudo install rocketchat-server
root@localhost:~# sudo snap set rocketchat-server caddy-url=https://{Domine-Url}
root@localhost:~# sudo snap rocketchat-server caddy=enable
error: unknown command "rocketchat-server", see 'snap help'.
root@localhost:~# sudo snap set rocketchat-server caddy=enable
root@localhost:~# sudo snap set rocketchat-server https=enable
root@localhost:~# sudo rocketchat-server.initcaddy

If no errors where found is safe to restart rocket.chat and Caddy:

yahyaahrika

            $(document).on('click', 'a[href^="#"]', function (e) {
                // target element id
                var id = $(this).attr('href');

                // target element
                var $id = $(id);
                if ($id.length === 0) {
                    return;
                }

yahyaahrika

  [HttpPost]
        public ActionResult Create(string data ,int? idwebsite , DateTime? datetime)
        {
            if (ModelState.IsValid)
            {


                var item = data.Split('&');
                string[] parm = { };

yahyaahrika

	  <sessionState  mode="InProc"  cookieless="false" timeout="1500" >

yahyaahrika

   [HttpPost]
        public JsonResult Get(DateTime datestart, DateTime datefin)
        {

            SqlCommand SQL = new SqlCommand();
            DataTable table = new DataTable();
            Object DataFilter = null;
            try
            {