Could you move a little? I can't see the actual stored procedure.

No, really. Post the code for it. Or did you intend for a game of pin the tail on...

If you created a running total of hours using a windowing function, then you should be able to tell when an employee is into overtime hours. So if you had...

Oh okay. Thanks, Grant. At least it's a place to start!

And no DAX required! =)

Oh, super cool!!! I guess I'll look around for tutorials on it. You wouldn't happen to know any, would you? (Check learn.microsoft etc?)

Can you use this logic to unpivot that part? (so you get a column for each)

=IIF(Parameters!IncludePTO.Value=1,IIF(Sum(Fields!strCategory.Value="Payrole", CInt(Fields!mnyMTDActual.Value)

+

IIF(SUM(Fields!strCategory.Value="OT",Cint(Fields!mnyMTDActual.Value)

+

IIf(Sum(Fields!strCategory.Value="PTO",CInt(Fields!mnyMTDActual.Value)

,IIF(Sum(Fields!strCategory.Value="Payrole", CInt(Fields!mnyMTDActual.Value)

+

IIF(SUM(Fields!strCategory.Value="OT",Cint(Fields!mnyMTDActual.Value)

Use something like this in your report:

= IIF(Parameter!IncludePTO = "Yes", [Payroll] + [OT] + [PTO Sales], [Payroll] + [OT])

Or use a CASE statement in your T-SQL code to do it.

oh, right. That's the part I was going to try to avoid: SSIS.

Also, I wanted to maybe summarize them first, and then query... basically like if I were querying a...

• This reply was modified 2 years, 9 months ago by pietlinden.
• This reply was modified 2 years, 9 months ago by pietlinden.

So just follow the instructions for it in an article like this?

Create a Format File (SQL Server) - SQL Server | Microsoft Learn

oh god no don't use UNION ALL unless you really need to.

Why not just something like this to get all the records you need from each source?

INSERT INTO tempdb.TableName(col1, col2,...

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 2 years, 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...?