Database

SELECT Column1, Column2, (SUBQUERY1) [SOMEDATA]
FROM TABLE1
WHERE CRITERIA1 IS TRUE

UNION

SELECT Column1, Column2, (SUBQUERY2) [SOMEDIFFERENTDATA]
FROM TABLE1
WHERE CRITERIA2 IS TRUE

SELECT Column1, Column2, COALESCE((SUBQUERY2), (SUBQUERY1)) [SOMEDATA]
FROM TABLE1
WHERE CRITERIA1 IS TRUE
OR CRITERIA2 IS TRUE

CREATE PROCEDURE agsp_UniqueDocnum 
	@DOCUMENTTYPE AS NVARCHAR(15),
	@ORDERID AS INT
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	INSERT INTO ags_UniqueDocnum 
	(	CreationDate,
		DocumentType,
		OrderId )
	VALUES
	(	GETDATE(),
		@DOCUMENTTYPE,
		@ORDERID );


	RETURN SCOPE_IDENTITY();
END

SELECT agsp_UniqueDocnum('TEST', 0)

SELECT
    project.project_no,
    COUNT(commission_summary.project_no)                            
    FROM project 
    INNER JOIN commission_summary ON commission_summary.project_no = project.project_no             
    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()) )
    GROUP BY project.project_no