Run the script from this link to get the actual sizes and free space in the database.

http://bit.ly/tablespace

Are you getting any errors?

Have you checked for any blocking?

Or is it just that the shrink is running a really long time and never ending?

Somebody must have broken the...

Can you provide sample data and table structures so we can actually provide a working query for you?

lsalih (8/11/2014)

---

I ran the query against real data, and noticed the query does not take into account relationship_type. For example, mother and father can both have same phone. In that...

Evil Kraig F (8/11/2014)

---

I'd recommend going with the new style in 2012+. I haven't had the...

Check that out - you hit the Rare rank of UDP broadcaster.

Is your view materialized?

Thanks. Taking a look.

I'd like to see a link as well please.

I agree with Kraig.

Surely this can't be legitimate can it?

polkadot (8/11/2014)

---

SQLRunner,

Are you suggesting that my main problem is 'division by zero'?

At the bottom of my column of percentages I need the average of percentages.

I've tried

=AVG((Fields!To_Your_Store.Value+Fields!Lost_to_Competitors.Value)/Fields!TotalLeads.Value))

and result is...

Try the formulas posted on this link.

http://stackoverflow.com/questions/23230172/need-ssrs-expression-for-percent-of-change-that-avoids-division-by-zero-error

tstagliano (8/11/2014)

---

Also i need to clarify that the percent calculation needs to multiple against the sum of the count of employees by benefit. So for example Benid 1 may...

ronan.healy (8/11/2014)

---

so say I use something like this

SELECT * ...