It uses the recursive CTE to populate some memory tables, which are then used in a succession...

Thanks everyone.  I agree about not using PRINT statements, but I was not planning on adding this to the production code, just during the debugging process.  The reason I want...

Thanks for that - however, the question was pretty vague, and I believe that a perfectly valid answer to the question that was posed is PERCENTILE_DISC.

From the docs:

For example, PERCENTILE_DISC (0.5) will compute the 50th percentile (that is, the median) of an expression.

So I think you should have allowed this, given that the question simply...

Ahhh, I smell an upcoming question where the single and double quotes are changed

SPOILER ALERT

Strictly the first answer is also correct, I think, though less streamlined.

 

What Rune Bivrin said.

Thanks Jonathan AC Roberts.  In fact there was originally a key such as you suggest but it disappeared in a cut 'n' paste job.  The tables were created purely for...

Thank you very much Grant.  A very useful and comprehensive answer that chimes with my much more limited experience (only 25 years a dev!) and also with my innate caution...

I agree with all the answers above, apart from Stewart Campbell who not only found it "easy" but apparently has a version of SQL Server that works differently from everyone...

If there were any need to persist this, then I'd agree.  However, the script is merely to identify a set of users for later deletion.  The circumstances which have given...

Ah thanks Thom.  I've already replaced the CTE with a table variable (as it turns out I need to reference it multiple times in a much more detailed batch) and...

4*2 = 8

Could you provide a link to an authoritative resource, please?

I hadn't come across this function, but I confess that I struggle to understand the utility of it.  If you amend the SELECT statement thus

December 6, 2018 at 2:14 am

#2015636