spinningcat

var FiO2 = from query in _Context.VentilatorDatas
                     where query.PatInfoID == Convert.ToInt32(PathID) 
                     && query.DateVentilator < oneHourBefore 
                     && query.DateVentilator >= oneDayBefore
                     select (int?)query.FIO2.ToString().Min();

if (FiO2.First() != 0)
                {

spinningcat

        <!--Errors Found During Generation:
warning 6013: The table/view 'CeibaTeleICUTestDB.dbo.PatientLabData' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.
      

spinningcat

 public void insertsapsparameter(int facid, int pid, SAPS2DBModel sModel)
        {
            try
            {
                sabs2score sScore = new sabs2score
                {
                    facid = facid,
                    pid = pid,
                    ageValue = sModel.ageValue,
                    agePoint = sModel.agePoint,

spinningcat

select  cd.HASTA_ADI, concat(cd .HASTA_ADI, ' ', cd.HASTA_SOYADI) as HASTAADISOYADI,   SUM(md.MAP) as MAPSUM, SUM(md.NIMAP) 
AS NISAPSUM from MonitorData as md inner join  ClientPatientDemograficData cd on cd.HASTA_ID = md.PID inner join 
PatientDemograficData as pdd on pdd.SUBE_ADI = cd.SUBE_ADI where md.DateMonitor  <= DATEADD(hour, -1, getdate()) AND 
md.DateMonitor >= DATEADD(day, -1, GETDATE())  group by cd.HASTA_ADI, cd.HASTA_SOYADI;

spinningcat

with cte1 AS
       (select  cd.HASTA_ADI, concat(cd .HASTA_ADI, ' ', cd.HASTA_SOYADI) as HASTAADISOYADI, case when min(md.MAP)  > 
       min(md.NIMAP then min(md.MAP) else min(md.NIMAP) end as mapnimapvalue from MonitorData md inner join 
       ClientPatientDemograficData as cd on md.PID = cd.HASTA_ID where md.DateMonitor <= DATEADD(hour, -1, getdate()) 
       AND md.DateMonitor >= DATEADD(day, -1, GETDATE()) group by cd.HASTA_ADI, cd.HASTA_SOYADI
         ) select cte1*, case when mapnimapvalue < 90 then 1  else 2 end as point from cte1;
         
 error: [S0001][102] Incorrect syntax near ','.

spinningcat

with cteurine AS (
 SELECT s.PatInfoID,
        sum(convert(float, [Value]))
 from FluidBalanceManualData as s
       inner join (select PatInfoID,
                          LineNumber,
                          LineName,
                          ObservationDate,
                          ObservationTime,
                          MAX(CreatedDate)

spinningcat

WITH names AS (
        SELECT facid, patid, MAPpatientname, calculatedon, calculatedby FROM SOFAmap  UNION
        SELECT facid, patid, GCSpatientname, calculatedon, calculatedby FROM SOFAglascowcomescale  UNION
        SELECT facid, patid, URINEOUTPUTpatientname, calculatedon, calculatedby FROM  sofaURINEOUTPUT UNION
        SELECT facid, patid, CREATINEpatientname, calculatedon, calculatedby FROM sofaCREATINE UNION
        SELECT facid ,patid, PLATELETSpatientname, calculatedon, calculatedby FROM sofaPLATELETS UNION
        SELECT facid ,patid, PO2FIO2patientname, calculatedon, calculatedby FROM sofaPO2FIO2 UNION
        SELECT facid ,patid, BILpatientname, calculatedon, calculatedby FROM sofaBIL UNION
        SELECT facid ,patid, patientname, calculatedon, calculatedby FROM qsofaGlascowComaScale UNION
        SELECT facid ,patid, patientname, calculatedon, calculatedby FROM qsofaRespiratoryRate UNION

spinningcat

--CREATE PROCEDURE SOFAQSOFADATAPROCESSING
--as
WITH names AS (
        SELECT facid, patid, MAPpatientname, calculatedon, calculatedby FROM SOFAmap  UNION
        SELECT facid, patid, GCSpatientname, calculatedon, calculatedby FROM SOFAglascowcomescale  UNION
        SELECT facid, patid, URINEOUTPUTpatientname, calculatedon, calculatedby FROM  sofaURINEOUTPUT UNION
        SELECT facid, patid, CREATINEpatientname, calculatedon, calculatedby FROM sofaCREATINE UNION
        SELECT facid ,patid, PLATELETSpatientname, calculatedon, calculatedby FROM sofaPLATELETS UNION
        SELECT facid ,patid, PO2FIO2patientname, calculatedon, calculatedby FROM sofaPO2FIO2 UNION
        SELECT facid ,patid, BILpatientname, calculatedon, calculatedby FROM sofaBIL UNION

spinningcat

<?php
ob_start();
error_reporting(-1); ini_set('display_errors', '1');
session_start();
$dbname   = "...";
$dbhost   = "localhost";
$dbuser   = "...";
$dbpass   = "...";
$baglanti = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
//mysql_query("SET NAMES 'utf8'");

spinningcat

    $sorgu = $pdo->query("select pass from admin where admin = ?");
    $sorgu->execute($_POST["username"]); 
    $user = $stmt->fetch();