Rebel

(Chuck) Berry

Glasses

letter

Kitty

+1 - and first day back after a long weekend

What is the result of print @str ?

I think it will be empty as you are building @strqry up with a potential outcome that it will be null. When you...

ssurekha2000 (5/1/2014)

---

have a sp with 4 parameters the values of this parameters is obtained from application

currently i have

@transfrmdt date,

@transtodt date,

@cid integer,

@Type char(1)

DEClare @strqry varchar(max)

DEClare @str varchar(max)

If...

Re-reading you original post, a couple of questions for you.

What are the SLAHours and TotalDownTime values stored as (integer, decimal etc)? and what result are you expecting - 99.00294, 99.00,99...

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 ...

Work

BWFC (4/29/2014)

---

Stuart Davies (4/29/2014)

---

Ed Wagner (4/28/2014)

---

whereisSQL? (4/28/2014)

---

crookj (4/28/2014)

---

BWFC (4/27/2014)

---

rhythmk (4/25/2014)

---

Ed Wagner (4/25/2014)

---

TomThomson (4/25/2014)

---

BWFC (4/25/2014)

---

Stuart Davies (4/25/2014)

---

crookj (4/25/2014)

---

TomThomson (4/25/2014)

---

Ed Wagner (4/25/2014)

---

BWFC (4/25/2014)

---

Prism

Edit Stuart...

Ed Wagner (4/28/2014)

---

whereisSQL? (4/28/2014)

---

crookj (4/28/2014)

---

BWFC (4/27/2014)

---

rhythmk (4/25/2014)

---

Ed Wagner (4/25/2014)

---

TomThomson (4/25/2014)

---

BWFC (4/25/2014)

---

Stuart Davies (4/25/2014)

---

crookj (4/25/2014)

---

TomThomson (4/25/2014)

---

Ed Wagner (4/25/2014)

---

BWFC (4/25/2014)

---

Prism

Edit Stuart beat me to...

David Burrows (4/25/2014)

---

SELECT

'Type'[Type]

,SUM(CASE WHEN code='09' THEN Amt/100 ELSE 0 END) AS [Col1]

,SUM(CASE WHEN code='10' THEN Amt/100 ELSE 0 END) AS [Col2]

,SUM(CASE WHEN code='11' THEN Amt/100 ELSE...

Reflect