Database

Dhyanga wrote:

right direction on how to resolve this issue.

;with cte as 
(
	SELECT distinct
    p.project_no
    FROM @project p
    INNER JOIN @commission_summary cs ON cs.project_no = p.project_no             
    WHERE p.sales_no = @designerId 
    AND (p.status = 'construction' OR p.status = 'finished') 
    AND (cs.startup_check_date is NULL OR CONVERT(char(10), cs.startup_check_date, 120) = '1900-01-01' OR CONVERT(char(10), cs.startup_check_date, 120) >= '2021-01-01') 
    AND (cs.finished_check_date is NULL OR CONVERT(char(10), cs.finished_check_date, 120) = '1900-01-01' OR CONVERT(char(10), cs.finished_check_date, 120) >= DATEADD(month, -1, GETDATE()) )
)    
select COUNT(*)                            
from cte

$designerId = (rtrim($row1[0]));

$query2 = "
WITH cte AS 
(
    SELECT distinct
    project.project_no
    FROM project
    RIGHT JOIN commission_summary ON commission_summary.project_no = project.project_no<br />
    WHERE project.sales_no = '$designerId'
    AND (project.status = 'construction' OR project.status = 'finished') 
    AND (commission_summary.startup_check_date is NULL OR CONVERT(char(10), commission_summary.startup_check_date, 120) = '1900-01-01' OR CONVERT(char(10), commission_summary.startup_check_date, 120) >= '2021-01-01') 
    AND (commission_summary.finished_check_date is NULL OR CONVERT(char(10), commission_summary.finished_check_date, 120) = '1900-01-01' OR CONVERT(char(10), commission_summary.finished_check_date, 120) >= DATEADD(month, -1, GETDATE()) )
)<br />
SELECT COUNT(*) FROM cte";

$result2 = sqlsrv_query($conn, $query2) or die(" getDesignersWithProjectsKeyValuesByLastName " . LINE . " - " . $query2 . " - "  .  print_r(sqlsrv_errors()));
if (sqlsrv_has_rows($result2)) {

    $row2 = sqlsrv_fetch_array($result2);
    $projectCount = $row2[0];

    if ($projectCount > 0) {

        $keyValue = new KeyValue();
        $keyValue->setKey(rtrim($row1[1]));
        $keyValue->setValue(rtrim($row1[0]));
        $keyValues->add($keyValue);

    }

}

Quote:

what's stored in the database (SQL Server) as a Date or DATETIME column, is just a string formatted to a particular ISO format, labeled as something special or unique.

Quote:

I needed a consistent way of working with dates already written, so I choose the ISO120 format. ISO120 just makes it easier to fabricate new dates, and do comparisons in PHP8.

Quote:

I didn't want to change the database because it has 26 gigs of data.

date (Transact-SQL) - SQL Server | Microsoft Docs[^]

Storage size: 3 bytes, fixed

Mike Ahrens wrote:

Snowflake Azure database system