Thanks so much for the quick response!  It's a difficult thing to Google, and I only use the ranking functions occasionally.

This returned exactly what I wanted:

I don't know either.  It's extremely frustrating that the primary software I use to do my job has so many problems with the interface itself. 

I'm changing the...

I'm wondering if this has something to do with IE?  The "About" information from SSMS says 9.11, but I have 11.54 installed.  I suppose SSMS IE is different than the...

Well, I guess I answered my own question.. unless someone can offer a better solution:

with a as (

select 'start' [eventtype],cast('2016-05-17 08:00:00' as datetime) [eventdatetime]

union select 'start',cast('2016-05-17 09:10:00' as datetime)

union select...

The intent was to avoid having to do a complete code and proc sweep to implement this change. I'm not trying to avoid the structure of the table,...

Yes, that was the answer I was looking for. I ended up being able to tweak my formulas to come up with the calculated columns I needed:

TotalPayments:=CALCULATE(SUM(Payment[PaymentAmount]),FILTER(Payment,Payment[CustomerID] =...

I am just trying to get a list of reports in the ReportServer catalog that have not been executed recently, knowing that execution log contains last run information (partial).

Simply stated,...

You can also do the same thing in your report query. Let SQL Server handle the heavy lifting.

SELECT LEFT(mycol,50) AS [firstPart], SUBSTRING(mycol,51) AS [secondPart], ...

You may be able to fix that issue by flushing your IE cache.

in field1 use this expression to get the first 50 characters (for instance):

=LEFT(Fields!FieldName.Value,50)

in field2, basically do the same thing:

=MID(Fields!FieldName.Value,51,LEN(Fields!FieldName.Value))

I can tell there is a slight hesitation the first time I type in a query in a new query window at the time when it should be popping up...

the working and non-working databases have identical settings.

I had the Max Script size set to 1MB, but it doesn't matter what it is set on, does not help. All...

Microsoft SQL Server Management Studio11.0.5058.0

Microsoft Analysis Services Client Tools11.0.5058.0

Microsoft Data Access Components (MDAC)6.1.7601.17514

Microsoft MSXML3.0 5.0 6.0

Microsoft Internet Explorer9.11.9600.17239

Microsoft .NET Framework4.0.30319.18444

Operating System6.1.7601

I'm used to the Intellisense being pretty quirky.. It's...

Also, the users affected are connecting using Windows Authentication, and are members of an AD group that has been granted SYSADMIN on the db server in question, and I ensured...

SSMS is 2012 also. We have a couple developers using SSMS 2014.

This appears to be the case for several different users for only these databases on this server, running...