In a development, or production, environment you should really be running the SQL Services under a proper network login. They don't need to be the same across the board (Agent...

Seems Spiff beet me to it before I finished!

Thanks. The fact the it's not actually 3rd normal was grating on me, so i've changed my tables a little for the moment (I can change in the query though)....

Having a quick look at your table, they don't appear to be in 3rd normal form. Is a visitor limited to only 3 visits? What happens if they visit a...

Thanks Kiran,

I would still suggest providing those create and insert statements...

Welcome to SQL Server central.

Just having a look at your post, it's really difficult to read your data, especially with a lack of commas. Have a read of the...

When running as an Agent Job, the user that the SQL Server Agent is running on needs access (and any other rights it might need) to that folder. If you're...

This almost sounds like possibly a rounding issue. What sort of value is your sp returning? If it's a decimal, is the format SSRS no set to display decimals, and...

Isn't this a duplicate of http://www.sqlservercentral.com/Forums/Topic1813840-3077-1.aspx ? Try to keep it to one topic for a question, it makes it confusing. I have answered in your original topic.

wendy elizabeth (8/30/2016)

---

1. Where would you place this script and why? I am thinking the script could be placed in a trigger, as part of a nightly cycle that updates...

You need to include all of these tasks in a Sequence container. This will process each task in a "transaction". If one fails, you can set up SSIS to roll...

In the groups pane, click the down arrow on the right hand side and select Advanced mode.

Select the group you wish to repeat(which will likely be called "(Static)" and be...

The Reporting Services database is purely for deploying your RS data and reports to. it holds your security settings, and stuff like that, but where you run the service could...

See new answer 😛 (yes double posted to get a subscription email off :P)

Brain fart. Will edit again in a bit.

Edit: Answer number 2!

Would this work. In the filter, add the following expression (replace with your paramter and date fields):

=iif((Fields!date1.Value = Parameters!DateParam.Value) or...