That's what the second query I posted does. NEWID() returns a random number so ordering by it and then doing a TOP returns a random set of records each time...

Shot in the dark, since we don't have answers to Phil's questions, but here's a guess. I built this using AdventureWorks2012

SELECT [Name] AS TerritoryName

, t.TerritoryID

, tc.CustomerID

, tc.AccountNumber

FROM Sales.SalesTerritory T

CROSS...

write a stored procedure and assign him execute permissions on it?

This[/url] should be a good starting point.

David,

you could modify your stored procedure so that you can pass in a date and use something like this in your filter

If you could use DATEFROMPARTS, you'd be in the...

Not much to go on, but if each delegate is worth a specific amount, then you can do some counts and simple multiplication to compare to your break-even amount.

Without more...

Not a lot to go on.

How are you prompting the user for a date? What data type is your parameter?

Your stored procedures aren't really prefixed with sp_ ? You know that's for system stored procedures, right?

I did mine differently. I checked for existence of both class types in the "attends" table...

CREATE TABLE Student(

StudentID INT IDENTITY PRIMARY KEY,

FirstName VARCHAR(10) NOT NULL,

LastName VARCHAR(15) NOT NULL

);

GO

INSERT INTO...

If you have tons of databases to do it on, you could create a cursor to loop through the databases and then run the SQL to enable service broker. ...

You mean something like this? You'd need a Calendar table

SELECT *

FROM Calendar

WHERE TheDate>=GETDATE()-90;

toggle the visibility by making it depend on an expression might be an option.

you can only filter a dataset as a whole, not just a matrix or whatever where you use the dataset. Unless there's something I've been overlooking all this time.

One option might be SSIS to a new database? (then you can clean in between... in the SSIS pipe).

it's a star schema. It's just normalized a different way. One relatively painless way into understanding some of star schemas is Rob Collie's book "DAX Formulas for Power...