I apologize for the long delay in replying. I actually started a new job yesterday and have spent the last two weeks prepping the old one for my departure,...

I resolved the issue. Sometimes it just takes taking the time to document the issue and then posting it, because the answer came as soon as I saw it...

I apologize for the lack of clarity. The Stored Proc. that creates the table, drops it at the start. I scanned all the queries run around the time that...

Thank you for your reply. I haven't seen anything further up the trail; but I'll keep looking. I ran a Sql Profiler trace last night; but of course...

Thank you very much for the script CowboyDBA! I have searched for too long to try to display the same information that is in the "description" section of the...

Thank you for the clarification, I was aware that MAX is an aggregate; but you use it in such a way as to allow each row to be its own...

Thank you so much for your code. I have been looking for two days for someone to list a simple example of how to "pivot" rows and columns WITHOUT...

Thank you very much for the insight.

Good point. Only this is just a small part of a much larger dataset that all has to be in the same matrix. Unfortunately, SSRS does not like...

BAM! Well done sir. This works perfectly!

Luis,

I spent some time and got this to look a little better and hopefully will clear up some of my post.

What I need is a table that gives one row...

Thank you for your help. I in fact do have a calendar table setup with code from: http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

It comes in very handy.

I will see if I can...

Trevor's Script:

$siteUri = "[yourSharepointSiteHere]"

$proxy = New-WebServiceProxy -Uri "$siteUri/_vti_bin/ReportServer/ReportService2010.asmx" -UseDefaultCredential -Namespace "SSRS"

$proxy.ListSubscriptions($siteUri) | Export-CSV -NoType -Path c:\ReportsSubs_List.csv

Trevor's blog post to get more info:

http://sharepoint.nauplius.net/2013/12/quickly-identifying-reporting-services-subscriptions/

Major props go out to Trevor Seward on TechNet for providing a way to see all the subscriptions via a PowerShell Script.

http://social.technet.microsoft.com/Forums/sharepoint/en-US/6950236a-61a4-4430-bc1c-ec4a50555e03/where-can-i-find-what-reports-are-associated-with-which-shared-schedules?forum=sharepointadminprevious#6950236a-61a4-4430-bc1c-ec4a50555e03

Seriously,

Thanks Trevor

:w00t:

I don't know why I had a mental block for doing it this way; but this is perfect. All 868 rows returned in less than 1 second. Brilliantly...