You will get better responses if you provide some more test data with your required results.

Also you should make it consumable so in a format like:

DECLARE @Planning_Proposal_Temp...

;WITH MyTable AS 
(
    SELECT * FROM (VALUES
    ('A', '06/11/2019 09:00', '06/11/2019 09:15'),
    ('A', '06/11/2019 09:05', '06/11/2019 09:20'),
...

Here are two methods:

IF OBJECT_ID('tempdb..#SlowInserts','U') IS NOT NULL BEGIN
    DROP TABLE #SlowInserts
END
GO
CREATE TABLE #SlowInserts(Id int IDENTITY(1,1) NOT NULL, Comment varchar(50) NOT NULL)
GO
SET NOCOUNT ON
DECLARE...

I just took the columns out of the CONCAT from my previous query so they are separate columns, I think this is exactly what you have asked for:

            
November 5, 2019 at 11:54 am
            
#3695083

            
            
                                                
        

Hi Jonathan

Thank you very much for your help, which is greatly appreciated.

However, I was probably not so concise in describing what I need. My goal is to produce new...

;with cte as
(
    select ts.sensor,
           ts.temperature,
        ...

I think EOMONTH was introduced in SQL 2012 and this is the SQL 2008 board.

The reason it is ordered is the database engine will need to do a sort to group all the columns in the group by that are equal together. From your...

From your description it sounds like you want it to use OR instead of AND:

 SELECT *
   FROM Cars c
  WHERE c.Origin <> 'USA'...

I don't know why the query is suddenly taking longer. I just had a quick look at the SQL and saw that bit looked a bit odd. I don't think...

select s.c1,s.c2,s.c3,  COUNT(*)*IIF(m.c1 IS NULL,0,1) cnt
  from stg_tbl s
  left join main_tbl m 
         on m.c1=s.c1
...

Not dynamic, but if you know the values that will appear in item then:

select a.name,
       sum(case when b.item = 'red' then...

This bit looks odd and long-winded:

AND EXISTS (
SELECT 1
FROM (
SELECT PARTY_ID
FROM C_B_ACCOUNT WITH (NOLOCK)
GROUP BY PARTY_ID
HAVING count(1) = 1
) A
WHERE A.PARTY_ID = ACCT.PARTY_ID
)

I would write it like...

It could be that someone is creating large tables for temporary storage in tempdb. I don't see anything wrong with this if they have done it to improve the performance...

I see your description and your code but I still can't figure out what you're trying to do.  Are you simply trying to show what the Thursday week start...