Read that maybe 20 times before I understood. LOL Let me see if I have this right... If this were a "normal" table of component parts...

CREATE TABLE Component(ComponentID INT IDENTITY...

If you have a Calendar table that's similar to one you would use for a Date dimension in DAX/SSAS Tabular, you could just specify the start and end dates of...

https://www.sqlshack.com/get-details-of-sql-server-database-growth-and-shrink-events/

AutoShrink = True?

No. Just No.

progress! I created a Table-valued function to do the BOM stuff, then used CROSS APPLY to join it to OrderDetails, and it worked. (It's an approximation of a Work Order...

Same as mine, except I put the column names at the beginning.

Glad you sorted it out. I didn't want to just give you the answer, because then you wouldn't learn...

Oops, yes, I did miss it.  This is what I used. (Funny I would get the answer right and then miss copying it... the easy part!)

SELECT AllergyName
,LowStart...

This is how I did it...

SELECT AllergyName
,LowStart = MAX(CASE WHEN ScaleValue = 'Low' THEN ScaleStart END)
,LowEnd = MAX(CASE WHEN ScaleValue = 'Low' THEN ScaleEnd END)
,ModerateStart = MAX(CASE...

I could do it like this, I suppose...

use AdventureWorks2017;
go

-- what parts are in stock
SELECT currInv.ProductId
, currInv.TotalQOH
, sod.OrderQty
, rt_Sold = SUM(sod.OrderQty) OVER (PARTITION BY currInv.ProductID 
ORDER BY soh.OrderDate
ROWS...

I'll give you a hint... MAX( CASE WHEN...)

It's a LOT of that.

Jeff Moden posted an article on Crosstabs... that might help too. (Don't want to give the game away... I...

IF NOT OBJECT_ID('tempdb..#AirAndPollenScale') IS NULL
DROP TABLE #AirAndPollenScale

CREATE TABLE #AirAndPollenScale(
[AllergyScaleID] [int], 
[AllergyName] [nvarchar](max) NULL,
[ScaleStart] [int] NULL,
[ScaleEnd] [int] NULL,
[ScaleValue] [nvarchar](100) NULL,
)


INSERT #AirAndPollenScale ([AllergyScaleID], [AllergyName], [ScaleStart], [ScaleEnd], [ScaleValue]) VALUES (1,...

I would swear I've seen this before. I think I solved it by running SSMS as local administrator, and it will work. Right-click SSMS, click 'Run as administrator' and then...

It's hard to tell without seeing at the very least the table definition of tApplication, and a few dummy records. But 105 columns is a lot - it's possible that...

I need to delete the rows where status = 1

DELETE

FROM TestPO

WHERE Status=1;

?

From your description, it's not at all clear what records you really want deleted. Which record(s) are duplicates? How...

Something I should practice... for sure!

I have to admit that my very first response to the question was "Can I do this with the dbatools PowerShell library?" I should have...