This looks extremely similar to a garment stock control system I spent a couple of years working on, some time ago. It makes more sense if the “Inventory” table is...

• This reply was modified 3 years, 5 months ago by  ChrisM@Work.

"I can also confirm that both of these properties have been available since at least 2016. I did have to check to make sure.  I don't have any instances earlier...

;WITH ReportMatrix AS (
SELECT d.[Year], x.[Month], d.[Site], d.[Account]
FROM (
SELECT [Year], [Site], [Account]  
FROM #TestData
GROUP BY [Year], [Site], [Account]
) d
CROSS APPLY(VALUES ('01'),('02'),('03'),('04'),('05'),('06'),('07'),('08'),('09'),('10'),('11'),('12')) x ([Month])
)

SELECT m.[Year], m.[Month], m.[Site],...

Hi folks

I can't find anywhere else to ask this, so here it is. SQL Server 2017 Standard Edition is restricted to 24 cores. Does this mean...

Hi folks

I can't find anywhere else to ask this, so here it is.

SQL Server 2017 Standard Edition is restricted to 24 cores. Does this mean that the licencing cost is...

Happy New Year, Threadizens.

It's been ages since I had enough time to visit here and actually post something, and I wasn't sure if I'd have time today but there were...

• This reply was modified 3 years, 11 months ago by  ChrisM@Work.

I am looking  for an example on how to query several tables, around 50 tables, to find all unique records between them. I cant find anything other than a...

Here's exactly what I meant by using Paul White's method to grab the first column values only, then using that result set as the source for further processing. The first...

I can understand SQL having to scan the table / index, but I don't see why SQL would need to do a sort.  Btw, an asc index will...

I'm looking at that, but it's not going well. I have three columns,...

Here's one way of obtaining the distinct first-column values without performing an index scan.

https://www.sqlservercentral.com/forums/topic/calculating-interest-query/page/4/#post-1244493

Oh yeah, I forgot about the filter. It's actually the same filter as is used in my original query, but I forgot to put it back in when testing...

All the indexes show non-clustered. I'm sure I had a clustered index on this originally, but I've done a good bit of expermenting with this table, and probably forgot...

That index is seriously wide, and filtered. It will only be used by queries which have the same filter.

What proportion of the table columns does it include?

What's the clustered index...

• This reply was modified 4 years, 3 months ago by  ChrisM@Work.

I think the optimiser doesn't use the index because there's no benefit in doing so. If you scale up the row count to something sensible and add a column to...