If you are exporting different companies, how are you telling the report to export for the different companies?

The best way to do this would be to have 5 different subscriptions....

To use queries such as this you need to enable Ad Hoc Distributed Queries.

This does have certain security implications, so here's the link to MSDN, which explains about it, and...

I feel like a Merge would be a better idea here, rather than a delete and insert. Then you can update or insert, depending on if the record is there...

Although this doesn't answer your question, why does a customer have the ability to delete a table? If this is something they definitely shouldn't be doing, it most definitely worth...

You posted this last month as well, asking exactly the same question.

I'm pretty sure that this isn't a function of SSRS though. I haven't seen it in 2008 to...

This...

Sounds like your after a *shivers* Cursor.

Would this do the job?

Create Table #Loop (ID int, Name varchar(20))

Insert into #Loop

VAlues (1, 'Steve'),

(2, 'Jane'),

(3, 'George'),

(4, 'Harold')

Declare @Name varchar(20)

Declare Loop_Cursor Cursor...

I'm not 100% sure on the logic of your table here. What I've created below definitely isn't scalable if you were to have a department without 2 employees (what even...

How are you going to show arrows in a chart? Visually this should be pretty apparently if you are showing it in a chart, as the line/bar will be higher...

A Foreach loop is what you're after.

I have something similar, that checks our SFTP "In boxes" once a day to see if we're received any new files. Files in specific...

If you're using the calendar, that shouldn't be a problem. Are you able to confirm the browser they are using?

When you say latest version, do you mean 2016? if so, 2016 has had an overhaul with Mobile Devices in mind. Here's a link to the MSDB article about creating...

This sounds like you're entering a date that isn't valid but effectively "could be". Take, for example 31 January 2016. I would type this as 31/01/2016, but an American would...

Thom A (6/3/2016)

---

The fact that the error says that your connection failed, really doesn't suggest there's a problem with the variable mapping, and is the connection manager. Especially if you...

The fact that the error says that your connection failed, really doesn't suggest there's a problem with the variable mapping, and is the connection manager. Especially if you have the...