Nerd topics are an interesting "place" to learn to write better.  I remember several years ago revisiting a question that I first came upon when I was using Access (before...

Oh, like that! I was going to say this question reminded me of the "Which pilots can fly all the planes in the hangar?" question from SQL for Smarties (I...

CREATE TABLE and INSERT scripts?

Wouldn't you have to "explode" the kits so that they return their component parts and union that with the non-kit records, and finally sum that? Or...

DATEFROMPARTS?

I'd think this is such a bread and butter kind of thing that HR has to do that someone has already written an application that does this. And since they...

0 PRECEDING?

isn't that CURRENT ROW?  Doesn't matter to me, but if you can write the query in a standard way, it's easier for people to understand what your code is...

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

Maybe I'm just not seeing it. Are you just trying to create a running total?

You need a windowing function to do that...

SELECT trID,
DiffAmt,
rt = SUM(DiffAmt) OVER (ORDER...

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 3 years, 4 months ago by pietlinden.
• This reply was modified 3 years, 4 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