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...

Why not just use ROW_NUMBER() and then add a constant to it and do the whole update in one go? I don't think you need a cursor for this...

Would that make it too easy? (StudentID, LockerID, StartLease, EndLease) or similar?

Isn't this as simple as

School--(1,M)--Locker--(1,M)--LockerAssignment--(M,1)---Student

and

LockerAssignment--(M,1)--SchoolYear

From that you can join the tables and get all the current locker assignments etc.