Why not go crazy and use a WHERE clause to find the records that are different and only update those?

SELECT DATEDIFF(day, [ExpiredDate], GETDATE() )

FROM MyTable

use tempdb;
go

SELECT x.ExpiredDate
, isfuture = iif(x.ExpiredDate>getdate(),'future','past')
,  daysAgo = DATEDIFF(day, getdate(),x.ExpiredDate)
, PassTest = IIF(DATEDIFF(day, getdate(),x.ExpiredDate) = x.ExpectedDaysAgo,1,0)
FROM (VALUES
('2021-07-25 15:29:09.000', 6)
,('2021-07-28 17:31:22.000', 9)
,('2021-07-19 04:02:54.000', 0)
,('2021-07-18 12:01:31.000', -1) 
)...

A big part of your problem is that you data is pivoted, and you need to unpivot it to store it. Unpivoting something like this using PowerQuery is child's play. Basically,...

• This reply was modified 4 years, 8 months ago by pietlinden.

That will work. The basic idea is that you have to have the first query execute, and then the second work on the first... and that's essentially what a CTE...

Sorry, some days I'm dumber than a freaking rock. I think your problem is that FundVariance doesn't have a value when you're trying to filter it. It's evaluated after the...

• This reply was modified 4 years, 8 months ago by pietlinden. Reason: me mordio la estupidez!

Why not create a fiscal calendar? It's a whole one record per day. They're super helpful if you're doing stuff like sales analysis. Then this is ridiculous easy.

            
July 3, 2021 at 3:49 am
            
#3903064

            
            
                                                
        

Put all your queries and stored procedures as close to the data (back end) as you can. Especially if it's in Azure.

I think I can put multiple Access append queries...

• This reply was modified 4 years, 8 months ago by pietlinden.

You've got that many points and you can't post create table and insert scripts? =(

Anyway, do everyone a favor and post them so they don't have to waste their time...

use a WHERE clause or a join in your UPDATE statement so the records you don't want updated don't get updated?

Why not? You could add filter parameters etc.

CREATE PROCEDURE MyProc
            @param1 VARCHAR(10),
          ...

Create a measure for Total Sales, and another measure for Total Transactions, and then a third where you subtract the two. (I like building simple measures and then combining them...

Aren't checkbox values either 1 0r 0?

Once this is converted to a time, this should be easy... get a MAX of the time, and then subtract 30 mins, so something like  [theTime]>=(SELECT DATEADD(minute,-30,MAX(Time))

(Is it a good idea to record the size of the various tables you want to track by inserting the recordcounts for each into a static table?)

I've done this by...