Call me old -fashioned, but I prefer functions to perform a single...

• This reply was modified 3 years, 8 months ago by  Sergiy.

I

I have to strongly...

@Sergiy - for sake of consistency can you give your version (condensed) that gives both outputs I gave - and taking in consideration that either today or yesterday could...

The script from frederico seems to be too complicated.

Here is much simpler version.

For ease of understanding I put it into sequential steps:

DECLARE
@today [varchar](12) = '44:10:27.766',
@yesterday [varchar](12) =...

You obviously have problems with handling quotes in dynamic SQL.

Before you try execution...

Yes, most definitely.

Since my last post I tried:

SET @whereClause = '[dtmDocDate] >= DATEPART(dy, 2020-09-01)'

with the same result.

However, I think I have discovered the underlying issue.  The script of which...

Incorrect syntax?

SET @whereClause = '[dtmDocDate] >= ''2020-09-01'''

Is it what you're after?

DECLARE @BatchId int = 10 ;
with BatchOrders (InvNo, BatchID) as (
select 1111, 1)

select count(InvNo) as RecordCount, @BatchId as BatchId
from BatchOrders
where BatchId = @BatchId

I found from personal experience that function performs better than CTE.

Probably, saving on...

Over my career I've rarely seen anywhere with an "as live" environment that wasn't production.  For that reason I don't particularly think this is a cloud only or even...

When it comes to databases the concept of cloud computing eliminates any possibility of proper testing.

In an ideal world databases must be future proof, so the testing must be performed...

Yeah, it's government for the "cloud" provider...

My team leads' gone over the contract and it's not specified in the contract.  What he's trying to collect, information-wise, is how much...

INSERT google_file_store VALUES
('alt1.txt','The bullet points of this are:'),
('alt2.txt','- sometimes bull trading means selling bulls on the market;')
('alt3.txt','- bear in mind that ball bearings might not be relevant...

I don't understand why you people are complaining about the lack of automated DB tuning.

You've been given Auto Index Tuning - don't you have enough of it?

Want more?

Well, DDL is still code, right?

then yes, it’s in code. Of some kind.

🙂