Just work on the code

The issue with this seemingly trivial piece of advice is that we have no idea at this point what sacrifices to the god of SQL2019 we...

• This reply was modified 3 years ago by Kevin Gill. Reason: trying to fix a link

Ah nice I've used LAG so infrequently that I wasn't aware of that one. Thanks

declare @torig table (custid int, employeecount int, datadate date)
insert into @torig values
(1, 10, '1-Jan-2023'), -- 21
(1, 11, '1-Jan-2023'),
(2, 11, '1-Jan-2023'),

(1, 15, '2-Jan-2023'), -- 28
(1, 11, '2-Jan-2023'),
(1, 2,...

• This reply was modified 3 years ago by Kevin Gill.
• This reply was modified 3 years ago by Kevin Gill. Reason: grammar

Even if she already had permission in her own right though via an additional GRANT to Sallydev, it would still do nothing and answer 2 would still not be true...

Stewart "Arturius" Campbell (8/17/2016)

---

Interesting question, Bob, thanks

However, i noticed a slight inconsistency in the explanation, viz. When a NULL is inserted as a seventh row, Query 2 still returns 6...

Ah OK so I take it the question is still wrong and I haven't just lost my mind... As it's written now the "correct" answer is 1.7 but there is...

Hi Nakul, thanks for the reply.

You've confirmed my understanding of sp_configure which I then think means it would be worth a clarification in your article in the section headed...

I'm confused by the use of sp_configure and I can't find a clear source anywhere to explain it. If the "user options" is made up of a bitmap of options...

You would think that would work, but at the same time you'd think that doing it at the...

Yep - unable to see the article due to a redirect loop.

Though technically the answer is "it depends on the initial setting of SET ANSI NULLS..." 😛

Darn it I counted the 4's wrong after having a lightbulb moment about what 'With Ties' does. As I clicked the answer I knew it was wrong because it was...

Richard Warr (4/29/2013)

---

You get a point...

Noted, thanks 🙂

Grant Fritchey (2/6/2013)

---

Red Gate SQL Monitor (of course)

SQL Sentry

Confio Ignite

Our software is a good choice for general monitoring, up-time, guidance on performance problems, historical information tracking & custom metrics and...