Add a tablix to your layout, then put a rectangle in the cell you want to put these two values in. Then put the two textboxes (for the two...

Sounds like a "gaps and islands" question. You're looking for the maximum size of an island.

Is the same true if you use a common table expression to calculate the running total?

Dwain, I think you get it. The problem was that everything was in Access, and so I ended up writing some really crazy VBA to union the stuff together...

Can you just create it as a table-valued function?

CREATE FUNCTION [dbo].[GenerateCalendar]

(

@FromDate DATETIME,...

Great! Glad to help.

When in doubt, test it out in TEMPDB.

Either use

USE TEMPDB;

GO

... and then paste your code here

OR prefix the tablename with a # sign....

CREATE TABLE #TableInTempDB...

This pretty much explains it -- just run the queries and see what happens:

USE tempdb;

GO

CREATE TABLE SomeDates(TheDate DATE);

INSERT INTO SomeDates VALUES('1/11/2014');

INSERT INTO SomeDates VALUES('1/12/2014');

INSERT INTO SomeDates VALUES('1/13/2014');

INSERT INTO SomeDates VALUES('1/14/2014');

INSERT...

Do you mean 'Does it matter the order in which I declare variables and assign them values?' No. Not unless one is dependent upon another.

Not sure if this will help if you're querying a DW... this is one way:

SELECT c.CarMake

, c.Country

, c.EventDate

, c.RowNum

FROM

(SELECT CarMake

, Country

, EventDate

, ROW_NUMBER() OVER (PARTITION BY CarMake, Country ORDER...

Inside Access, right-click on one of your linked tables, select Linked Table Manager from the menu, and it will show you where the tables are pointing to.

Thanks for the help. I think it's closed. I tested it with grade 4, just to short-circuit the record creation, since the "fatal" grade is somewhat arbitrary. ...

You're welcome... if you run my code, make sure the CREATE TABLE code for Protocol is before the code for Enroll. (That part was confusing in my post, I...

You can do it using CROSS APPLY.

Read these two articles (definitely worth the read!):

http://www.sqlservercentral.com/articles/APPLY/69953/ (Part I)

http://www.sqlservercentral.com/articles/APPLY/69954/ (Part II)

(Basic plan)

Get the TOP 1 Values from the child table (pass...

"I cover this in my Common TSQL Mistakes SQL Saturday session..." (just not #272? Not coming to NashVegas?? Drat!

And don't forget MSDB. That's where all your jobs etc are stored.

Before the original server goes away, make sure you have a working SQL Server instance where you need...