your DROP TABLE statement has an extra space, here's the corrected version, and I added in one in the 2008 & After section if you wanted to order by lastname...

right, but that's basically exactly what an SSRS subscription does. run a report from SQL, export in some format, save it somewhere. Think you should use that avenue, since it's...

do you have an available SSRS server?

We can't see any sample data, so it's going to be harder to help. Can you generate dummy data and give us table structures so we can run it and...

use SSRS, set up the report and schedule it.

But, otherwise, you used to have to have a special file connection from codeplex to pull from/to SharePoint, not...

well that's interesting, Chris, thanks!

However, it only really works when it's within the same database, when I tried it on a view looking into other databases it gave...

So, Steve, how'd digging the car out go?

information_schema doesn't do that, you are correct that you would have to parse the view definition to see what tables and fields are affected. That is the purpose of a...

are you trying to do =(ReportItems!YTLP.value + ReportItems!TSA.value) / ReportItems!YT.value ?