This works except for the "Top 4" rule, but you can do that using CROSS APPLY.

use tempdb;
go

CREATE TABLE #Diags ([ChartProcedureId] UNIQUEIDENTIFIER, [DiagnosisCodes] VARCHAR(200))

INSERT INTO #Diags ([ChartProcedureId], [DiagnosisCodes])...

Congratulations on finding a relevant post that has the answer you need. Did you try it??

Something like this maybe?

use tempdb;
go

CREATE TABLE Reading ( readingDate date, quantity int);
GO
INSERT INTO Reading VALUES ('02/03/2023', 170),('02/02/2023', 90),
('02/01/0223', 160);

SELECT readingDate, 
quantity, 
prevQty = LAG(quantity) OVER (ORDER BY...

• This reply was modified 1 year, 9 months ago by  pietlinden.

I would use LAG([Recordcount],1) OVER (PARTITION BY TableName ORDER BY SomeDate)

I would use LAG([Recordcount],1) OVER (PARTITION BY TableName ORDER BY SomeDate)

Cascading parameters...?

Make your life easier.  Create a stored procedure in the database (or send the query to whoever is allowed to do it) , and then create a dataset in SSRS...

Reassemble the (date, hour, minute, second) back into a proper date and then use DATEDIFF?

Failing that, you'd have to check if ExitHour < EntryHour, and then use (24 + ExitHour...

Sounds like you need to cross join the two tables (creates all possible combinations... be careful with these!), and then subtract out the matches.  (It would help us a LOT...

• This reply was modified 1 year, 10 months ago by  pietlinden.
• This reply was modified 1 year, 10 months ago by  pietlinden.

That's Oracle syntax. Are you connecting to a SQL Server database?

Divided We Stand: The SQL of Relational Division - Simple Talk (red-gate.com)

Read the article... that's how you do it in T-SQL. In DAX, well, that's a whole other kettle...

Something like this?

SELECT CustNo, TimeAmount AS Amount, 1 AS ExpenseType FROM #P
UNION ALL
SELECT CustNo, ExpenseAmount, 2 FROM #P;

.NET?

Which pages??? The first N records per parent? What does "a certain number" mean?

Could you give us a quick example?

wow. for that many points, that's a pretty terrible description.

For starters, here's your code fixed up a little:

use tempdb;
GO
CREATE TABLE ReportingPeriods(
StartDate DATE NOT NULL,
EndDate DATE NOT NULL,
PeriodID...