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

This sounds like it's supposed to be done in PowerBI, using DAX. Doesn't sound like a SQL question at all.

DDL = Data Definition Language (CREATE TABLE scripts, [INSERT] scripts, so we have data to work with).

you can see your data, but we can't. So we need some sample data...

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

Is this a DAX question or a T-SQL question?

Joe Celko wrote an article showing how to do this in T-SQL. I think the gist of it is that you count...

Here's a beautiful screenshot of my table!

<ducking>

Me too. It's weird, but I find the act of writing (not typing) helps me remember better. And I doodle to make sense of and plan things (like my terrible...

Are you trying to put all of this stuff into a single fact table? Don't. Hiring/Turnover is one table, Sales etc is another. They share a Time/Date dimension, so summarize...