If you're counting values per day, you're missing the Calendar table. If you left join the Calendar table to the table of scheduled events, then it's stupid easy. You need...

Something like this:

SELECT *

FROM

(SELECT 1 as PersonID, '2016-10-21 11:00' as evntTime, 'CLOCK_IN' as evntType

UNION ALL

SELECT 1, '2016-10-21 20:45', 'CLOCK_OUT'

UNION ALL

SELECT 1, '2016-10-22 3:45', 'CLOCK_IN'

UNION ALL

SELECT 1,...

Power BI is, to some degree, like Microsoft took all the PowerPivot/tabular tools out of Excel and put them in a standalone application. You can use it for data modeling,...

Wendy,

You could do create a job to run a stored procedure on a schedule to do this.

If you wanted to just send messages, you could do something like:

1. open...

Use DelimitedSplit8K or something like it and then use LIKE in the join?

Something like this maybe?

DECLARE @NameTest varchar(20)

DECLARE @id INT = 1

SELECT *

FROM NameList WHERE FirstName = COALESCE(@NameTest,FirstName)

AND ID = @id;

I was using 2003, so things may have changed. I thought MS gutted security in Access... maybe I'm wrong.

One way is to create a place holder and use FIRST to get only one record (otherwise your report will error out when rendering).

Something like this:

=First(Fields!OpenToEnrollDate.Value, "Enrollment")

where you specify the...

Please do everyone here a favor and post them all together.

1. create table statements.

2. insert statements.

3. T-SQL for the queries you tried and how they're not quite what you're trying...

Funny, but when I run that query on MY computer, it says it can't find the table.

Did you look at the estimated and actual execution plans yet, or are you playing a guessing game?

Directly from Hardware and Software Requirements for Installing SQL Server 2016:

Installation of SQL Server 2016 is supported on x64 processors only. It is no longer supported on x86 processors

Didn't we already have this discussion? Is this not a repetition of this earlier thread?

I am under the impression that either you are describing something incorrectly or your design...

Sounds like you need a Matrix on your report, but it would be a lot easier to solve with some data.

Can you post some sample data?

A create table statement and...

If she's trying to learn DAX (which you can use in Excel, which she probably knows already), then get Rob Collie's book -- it's on his website powerpivotpro.com I...