Yes.

iv managed to send the report using a script, so i think if i can pass the email...

Mal

You don't need a separate report per supplier - just a separate subscription. You might need to change your report a little to get to where you want to...

Mal

Have you tried using subscriptions? You can specify parameters for those - not dynamically, as far as I'm aware, but all you need to do is pass the supplier...

Why not just incorporate the query that determines the parameter values into the report?

John

Have you tested the individual components of the flow to see where the bottleneck is? How long does it take to run the query locally? How long does...

Possibly. I get 2013-11-28 00:00:00.000.

John

Yes, I suppose that so long as your trigger doesn't cause itself to fire again, you should be OK. I wouldn't swear to that, though - you'll want to...

No cursors? Why not? You're looping through 100 servers, so even if you don't have an explicit cursor, the effect is going to be the same. This...

You can't pass a parameter to a job. Can I ask why you're reluctant to create a stored procedure? That would be the normal way of doing it.

John

You're doing this the wrong way. First, stop using sysobjects, which is provided for backwards compatibility with SQL Server 2000 only. Second, why do you need to use...

It's not clear what your requirement is, but since up UPDATE statement is effectively a DELETE followed by an INSERT, you'll need to query both the Inserted and Deleted virtual...

sqlcmd is nothing but a utility that runs SQL scripts. If it doesn't meet your requirement, please provide more information on that requirement and the reason for it. ...

No. If you're going to do it regularly, create an SSIS package or do it with the sqlcmd utility. You can run either of those from a job.

John

Please will you post the whole query, redacted or obfuscated as necessary?

Thanks

John

If you run the exact same query in a query window, do you get a row count in the Messages pane?

John