Thanks for the correction. I was looking at Reserved Keywords (Transact-SQL), but looked past the TSQL section into the ODBC section.

Note: In the first paragraph you state it has to be greater than 100, but then say it has to be greater than 300 in the next two.

It sounds like...

I suspect Jeff wants you to answer THIS (and in fact, any) question:

https://www.sqlservercentral.com/forums/topic/slow-execution-when-update-chemical-id-on-table-chemicalhash-so-how-to-enhance-i#post-4034307

Jeff Moden, May 17, 2022 at 1:10 pm:

Does the ChemicalHash table ONLY contain rows where the ChemicalID...

At a minimum, an EC2 instance will have an EBS volume for the operating system. You can add additional volumes.

What's the nature of the data on the EBS volume(s)? When...

Is this related to my response to https://www.sqlservercentral.com/forums/topic/slow-execution-when-update-chemical-id-on-table-chemicalhash-so-how-to-enhance-i suggesting using a hash for comparisons & indexing?

Hashbytes returns a varbinary(64) for that algorithm --  a very nice, efficient type for...

Please provide DDL (table definitions) & sample data as insert scripts as described in How to post code problems.

It's absolutely possible in cloud services. In addition to more conventional virtual servers and containers, I believe all offer "serverless" services (e.g., AWS Lambda) that provide on-demand resources for the...

Very closely related to https://www.sqlservercentral.com/forums/topic/slow-execution-when-update-chemical-id-on-table-chemicalhash-so-how-to-enhance-i#post-4034307.

As with that one, review your data types.

Why is almost every column [nvarchar](3500)? It looks like some tool auto-generated types, and nobody corrected them. Is every...

I'd start by reviewing data types -- Do you really have unicode data that requires nvarchar? And do you really need max size (not inherently bad if strings really are...

How many scenarios/rules are we talking about? Based on what you clarified, you may well have a case for a rules table/engine approach.

If many rules, if the rules change, and/or...

I'm not clear what you mean by rules-based updates. When you say "apply business rules to update my table", do you not also mean for inserts into that table? Based...

The error message, somewhat misleadingly, describes the problem -- you need to specify the columns in the insert statement if not inserting all columns corresponding to every column in the...

That's OK, but it's best to be clear about that so that volunteers know not to recommend platform-specific (TSQL) solutions.

Here's a tek-tips Pervasive forum: https://www.tek-tips.com/threadminder.cfm?pid=318

A calendar table is great for that.

But if you want to derive it dynamically, and you're always executing on the day following the end of the date range:

            
May 11, 2022 at 9:06 pm
            
#4031425

            
            
                                                
        

PSQL? Are you using postgres? You posted in a SQL Server 2019 forum.