Have you tried percentile_disc?

https://docs.microsoft.com/en-us/sql/t-sql/functions/percentile-disc-transact-sql?view=sql-server-2017

I would swear I checked a box, but apparently not. It's Sys.time() (not Sys.Time()), so both items corrected.

I'm not sure the FTC has a general reporting rule. They have rules over health data and there was (maybe law?) a draft on credit agencies, but I don't know...

No  worries, I figured it out. This migration has made me painfully aware of how poorly I sometimes describe things to developers. I'm more empathetic to users struggling to express...

It's compressing line feeds into one, removing blank lines.

When you write that it's not honoring them, I think of lines being combined.  It does honor a line feed, but removes...

OK, I think we have this filed somewhere, but I'll check on it.

Hmm, OK, let me try something.

SELECT *
 FROM dbo.Articles AS a
GO


-- two line breaks before this
-- Test as SallyDev
EXECUTE AS USER = 'SallyDev'
SELECT *
 FROM dbo.Articles AS...

Glad you like it

Can you post an image of what you want this to look like? From your description, it's hard to decide what things you want changed. We added scrolling, so there...

We keep hearing about data breaches resulting from data being exposed on the internet, meaning that a web search could access the data in un-encrypted form. There is more...

The idea of using colors is interesting. It's a gross way of looking at data. Do you color the columns, tables or databases? In our Data Catalog work with customers,...

In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/ I admit I haven't read too far into it,...

Yanks closing the gap, though not as quick as BOS.

Rockies seem to be trying to improve, but can't quite do it.

Storage should be easy. You have ideas of the current size and can guess at growth by looking at metrics for the dbs of database size. Allow for data growth/pad...

• This reply was modified 7 years ago by Steve Jones - SSC Editor.

It was new to me as well. Never set this.