Database

SELECT Column1, Column2, CASE WHEN CRITERIA1 IS TRUE THEN (SUBQUERY1) ELSE (SUBQUERY2) END As SomeData
FROM TABLE1
WHERE CRITERIA1 IS TRUE 
OR CRITERIA2 IS TRUE

CASE WHEN CRITERIA2 IS TRUE THEN (SUBQUERY2) ELSE (SUBQUERY1) END As SomeData

where
myString has_all (Pattern1, Pattern2)

Declare @Temp Table ([Id] [int])
Insert @Temp Exec agsp_UniqueDocnum 'TEST', 0
Select * from @Temp;

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.