This is likely not the best way to do it, but I think this should work the way you want (with the exception that your result set is wrong based...

I do like the idea, but like cooking, coding can have a million different ways to get the same result.
You want to cook the "perfect" steak.  First, anyone who...

I have a few thoughts on this.
You could have a stored procedure that was created with an "EXECUTE AS" in it that might cause it to run as a...

Since you can access the report on your desktop but not your mobile, I am expecting that your IT department has stuff blocked OR your local machine firewall is blocking...

Hello,

I have a thought on this.  Is it an error when Presentations has a value of 0 or when it is null?  You may want to also check...

If you are sure the URL is correct, then I'd be looking at firewall rules.  It also seems a bit odd to have your IPhone connected to VPN and connected...

Not sure how many people have seen the tool, but Idera has an extended events tool that has a similar feel to Profiler but more modern.  SQL XEvent Profiler is...

I've not had luck with the debugger either.  I always get errors about DCOM and possible firewall issues when I try to run the debugger.  Which makes sense as I...

As much as I hate to suggest it, this sounds like a job for a cursor.
Do you have xp_cmdshell enabled or access to use it?  You will need that...

Thanks for posting the solution!

I have not worked with using XML Name Spaces inside SQL Server, but now I do know how to do it.

Geeze, I seem to be bad at offering advice today, eh?

I apologize for the misinformation I provided.

That being said, and back to the OP, I don't...

Right... forgot that developer only went free with future versions.

With express, does that let you do SSIS?  I can't remember and it has been a very long time...

I think that you need to use Visual Studio 2008 (with the SQL Server Data Tools installed) and that should allow you to create SSIS pacakges to run against a...

Pretty sure Express doesn't include the advanced things like SSIS.  It should be part of the install (Integration Services).  I actually thought that SQL Server Agent didn't work with express...