I'm actually not too concerned about opening xlsx files, as they can't contain executable code (as far as I know). I downloaded and virus-scanned this one before I opened...

Just to emphasize what Jeffrey Williams is talking about...

    SET LANGUAGE ENGLISH;
 SELECT English = CAST('2025-09-06' AS DATETIME);

    SET LANGUAGE FRENCH;
...

I...

Sounds really good! I have never used SQL Prompt for this purpose but used it for other, mostly code formatting and best practices suggestions purposes.

QUESTION: is SQL PROMPT...

I'm still waiting for Scott to backup his claim with a link.

No.

1. What I said was that Scalar and mTVF functions both use BEGIN/END in...

I have 1 record(1row*2columns) from 1 select

and

a different select which can result in multiple rows but will always have 3 columns.

How can I repeat the 1 row next to...

Great points. I wasn't even thinking about that at all. Happily, I haven't received so much as a finger wag for dropping the ball. I mean, Steve is going...

Does you code actually look like what you posted?  I ask because there is no space between the terms "SET" and "Processed_Flag" and there needs to be.

We need to really emphasize what RatBak posted (re-quoted below)...

Do not expect performance improvements for queries, inserts,...

hi,

I heard many people saying "functions are denounced in tsql" is there any catch?

q1) need to know what are the cases where we should not use?

q2) should we avoid...

Interesting solutions, so far.  Let's try one more...

First, let's simplify the code to make the readily consumable data.  This is the best one of the better ways to post such...

I'm thinking that the answer is somewhere in the Actual Execution Plans.

p.s. That's a major hint for what you might want to provide.

• This reply was modified 1 years, 10 months ago by Jeff Moden. Reason: Add p.s

I was offered the help of a secretary once when I was getting around 350 emails per day so it was very hard to find the important emails mixed...

The concept of AI in the picture near the end of the article is actually pretty grotesque, IMHO.  Sex doll for both the body and the mind.  Possibly the worst...