Elliott Whitlow (6/7/2011)

---

So this is for a report? Do you have one report that generates the data for all Clients?

I think I understand your problem a bit more but...

GSquared (6/7/2011)

---

Does this return more than one row in some/all cases?

select NumericValue from ClientSettings where Setting like 'PushMaxCustomerRank'

If so, you'll get that error message, because you really haven't told SQL...

How can I modify it? I need to run both queries.

I need to run this as the number can be different for each client.

DECLARE @pushMaxCustomerRank int;

SET @pushMaxCustomerRank =

(select...