I'm not sure what you are trying to do, but COUNT(MyDateField) will count the not null MyDateField values.

Or are you trying to do do something else like COUNT(DISTINCT CONVERT(varchar, MyDateField, 112))...

Another method:

;WITH CTE AS 
(
    SELECT t.VisitID, 
           MAX(t.ActivityDateTime) MaxActivityDateTime
    ...

Here's a simple method to do that:

SELECT year1a.get_customeVal_1-year1b.get_customeVal_2 AS get_customeVal_3,
       year2a.get_customeVal_1-year2b.get_customeVal_2 AS get_customeVal_4
  FROM (SELECT 1 X) X
 CROSS APPLY(SELECT...

Have you tried setting the fetchsize to the number of rows you are expecting from the query?

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
...