Just a follow up on this, Jeffrey.

I have managed to get a working solution with your help.

I had been trying to read in the 'collection' variable from the For Each...

Thank you for the reply, Jeffrey.

Before reading your reply - I had done the following:

1 -Execute SQL task that gets all of the userID's that have attachments present in other...

Ensure your sysadmin hasn't left the 'User must change password at first login' checkbox checked when he\she created the service accounts.

• This reply was modified 5 years, 5 months ago by  CanIKickIT.

Ed Wagner (4/30/2014)

---

DonJunville: You'll be fine until you create a row that 200,000 hours. I know that may sound like an unreasonable value, but your design should allow...

Sorted.

@ Stuart

They are INT values and they are being returned at present via a view.

Thanks for the responses guys. I increased the decimal values from (4,2) to (5,2) and...

Stuart Davies (4/30/2014)

---

How about

SELECT CONVERT(DECIMAL(4, 2), CAST(NULLIF(t.SLAHours, 0) - t.TotalDownTime AS REAL)

/ CAST(NULLIF(t.SLAHours, 0) AS REAL) * 100) AS [%Availability]

FROM...

Thanks for the reply. Thats what I thought but needed confirmation.

I was asking the initial question because of licensing issues\constraints - we would only need to purchase one...

I'm not seeing any content either?