non-deterministic - "A property of a computation which may have more than one result."

So functions like NEWID() and GETDATE() are non-deterministic because they do not return the same result every...

What was it? (Sorry, that's just how I learn!)

SSRS will use the same sort order as the query/stored procedure you base the report on, so if you have the data sorted in your stored procedure, you're all set.

If...

COALESCE maybe? You might need to use a windowing function to get the previous row (LAG?) Something like

COALESCE(MyColumn, LAG(...))

Even if they do, so what? Just push a new front end out. Or is each user modifying his own front end? In that case, you might...

Maybe I'm missing something, because my results are different from yours... here's my SQL and results:

insert into Readings(MeterID, ReadingDate, Reading)

SELECT 4 ,'10/17/2013 12:00',5.1709 UNION ALL

SELECT 4,'10/17/2013 12:15',5.5319 UNION ALL

SELECT 4,'11/17/2013...

One thing I would do when loading the data is to timestamp the new records when inserting them.

DECLARE @TimeNow DATE = GETDATE(); -- sets the value of the variable to...

Why do you need to do that? Why not just index the ClientName/ID in the table, and then use a stored procedure to filter the data?

For example:

CREATE PROC usp_CompanyRecords

...

Here's one example of configuring SSRS to use gmail.

http://db-pub.com/forum-80534388/data-base-mail-configuration-using-gmail-giving-error.html

Good luck! Sorry I couldn't be of more help.

Pieter

Can you not change the spelling in your list? Otherwise, you would have to use a function to remove the spaces in your store names, and then match on...

Makes sense...

select 'WholeFoods' as Keyword

will never match 'Whole Foods'. If you fix that, your problem is solved.

You could use a UNION query and then just use NULL for the missing columns in the dataset with fewer columns. The sorting might be an issue. Hard...

You could use a UNION query and then just use NULL for the missing columns in the dataset with fewer columns. The sorting might be an issue. Hard...

Mario,

Just wondering, but why do you have Earnings and Amount in the same column? If you separated them so that they were in separate columns, it would make dealing...