Combine 2 sql quest which as declare statements

Question

Hello everyone,

I have below SQL Queries

Query - 1

Query - 2

How can join both queries

Answer 1

You can use UNION/INTERSECT/EXCEPT to combine your two queries but we don't have more information to help.
Screenshots of your queries are not a good way to ask question.

By looking at your query1 and query2,
you can remove the ORDER BY from your query1 and use UNION (ALL) to combine from there.

If you want more help, you can mark up your sample tables DDL/data and your expected result from your queries.

Answer 2

I have below SQL Queries

That are not queries, that are screenshots.
Please post the SQL queries as code here.

Answer 3

Hi @Abhilash Pullakanti

I want to create 2 CTE and then merge both tables into one.

Do you mean this ?

DECLARE @WorkbookViewID INT = 2,......  
   
;WITH CTE1 AS  
(  
 SELECT COLUMN_LIST,ROW_NUMBER()OVER(ORDER BY SKU,ProjectionDate)AS RN  
 FROM IMB JOIN IM ON ...  
          JOIN LP ON ...  
 WHERE ...  
),CTE2 AS  
(  
 SELECT COLUMN_LIST,ROW_NUMBER()OVER(ORDER BY SKU,ProjectionDate)AS RN  
 FROM IMB JOIN IM ON ...  
          JOIN LP ON ...  
 WHERE ...  
)  
SELECT COLUMN_LIST FROM CTE1 WHERE RN <= 100  
UNION   
SELECT COLUMN_LIST FROM CTE2 WHERE RN <= 100  
ORDER BY SKU,ProjectionDate  

Best regards,
LiHong