The WHERE clause in the sp is pretty standard:

WHERE p.utc_date BETWEEN @start_date AND @end_date

The report parameters have default values specified (expressions calculating the first and last days of the month)....

Yes, exactly.

The expected outcomes would be a specific date for each employee. For example, employee 1001 would have a projected 20-year date of 2018-01-01 plus the number of days they...

I see what you're saying, and I realized my mistake shortly after making that post.

I believe I have it figured out. When I first created the certificates, I made...

I believe the problem is that I haven't associated the application user with the certificate that was created on the application database. When I run the following, as you...

Thank you for the excellent article! I've attempted to make it work using certificates, but I'm still having a problem. Here's what I've done so far:

1. Created the...

I hadn't considered that, but it sounds like a really good idea. Thanks!

A readable secondary is a nice-to-have for reporting purposes, but isn't strictly necessary. I don't think the load generated by reporting will have much impact on production since reports...

I think this is a matter of necessity. In our...

Sorry, we're using a table variable and not a temp table. You can't add an index to a table variable, can you? We are pulling additional data from...

Ya, I know things won't work as well in 2008 as they would in 2012. I'm hoping to find money in the budget to upgrade, but it won't happen...

I've confirmed that this does indeed work, but it can take an ungodly amount of time. I have 125,000+ events and 175,000+ locations to work through and the query...

All data access is done through stored procedures, so my thought was to limit the account access to the sp's that it needs. Some of those stored procedures make...

The problem seems to be resolved by trimming the field used in the WHERE clause, although I'm not sure why. The field is a INT, but when I apply...

GilaMonster (7/11/2013)

---

Firstly, shouldn't

SET @query = 'SELECT * FROM OPENQUERY(' + @query + ','

actually be

SET @query = 'SELECT * FROM OPENQUERY(' + @linked_server + ','

?

As for the syntax error, print...