When eyeballing the data, how do you know where the start and end are? Is there any logic that can be applied to every single row? E.g everything after the...

What do you mean by 'looks dodgier'? Does it not return the correct data?

What's the issue with the first query in your recent post? Also, the second query can't be...

No problem.

It might be worth trying to find out why it happens in case it's likely to continue with a trigger.

You can use:

EXEC msdb.dbo.sp_start_job @jobid = 'job id of dds'

(https://msdn.microsoft.com/en-gb/library/ms186757(v=sql.100).aspx)

Ah I see. You could find the job ID of the data driven subscription by using the reportserver database, and then simply execute this job in your trigger.

Do you know...

If you're able to do data-driven subscriptions, why not just do that? I wouldn't have thought it would be much work to set up.

After adding your sample data into some temporary tables, this returned the same results as above:

SELECTp.PayID,

e.Name,

c.Name,

SUM(p.Amt1) SumAmt1,

SUM(p.Amt2) SumAmt2

FROM#UserPayments p

INNER JOIN#Employees e ON p.EmpID = e.EmpID

INNER JOIN#Companies c ON p.ComID...

I've used SSIS for something similar before and can walk you through what I did if that's an option for you?

Essentially I had an SSIS package run by a SQL...

It's not really irrelevant if it helps someone make the most sensible suggestion. I would usually use a function, but there may be instances where a procedure is better. Your...

What does the WHERE clause currently look like?

How straightforward is your function 'dbo.fnInsurance'? Is it possible to create a function from SH-SQL01 utilising the linked server?

I think one option is to use OpenQuery: https://msdn.microsoft.com/en-gb/library/ms188427(v=sql.100).aspx

E.g

SELECT ...

Sean Lange (2/24/2016)

---

jakebeliveau (2/24/2016)

---

tindog (2/24/2016)

---

Are you after something like this:

SELECT NT_ID,

100 * Frequency / (SUM(Frequency) OVER ())...

jakebeliveau (2/24/2016)

---

tindog (2/24/2016)

---

Are you after something like this:

SELECT NT_ID,

100 * Frequency / (SUM(Frequency) OVER ()) PercentageOfTotal

FROM ........

ETA:...

Are you after something like this:

SELECT NT_ID,

100 * Frequency / (SUM(Frequency) OVER ()) PercentageOfTotal

FROM ........

ETA: prefix with...

Could you post some sample data please? Will be easier to help.

Regards

Not A Gent

Maybe a bit late guys...