Smendle (9/22/2016)

---

The part I bolded above provides a default value...

Depending on what version of SQL you are using you can use the 'oneresultset = 1' parameter.

That being said I do believe that is a fairly recent change. You...

ChrisM@Work (9/6/2016)

---

Sean Lange (9/6/2016)

---

Luis Cazares (9/6/2016)

---

Sean Lange (9/6/2016)

---

I tried my hand at curing my own bacon for the first time. It came out of the cure Saturday morning and hit...

Top Gun

Looks like you are having a problem with the "Similar_Call" column but I'm not sure exactly what you are trying to accomplish...or at least your logic.

I've broken part of the...

WayneS (8/29/2016)

---

jasona.work (8/29/2016)

---

Brandie Tarvin (8/29/2016)

---

Well my thought is that there are many people who are absolutely terrified of interviews, who don't see themselves doing well no matter what they actually...

Walking

This seems too easy so maybe I don't understand but if you merely want to convert seconds to hours you can just do something like this.

DECLARE @seconds INT = 29732

SELECT...

Pirate

If you can post some DDL and Sample Data that would be very...

Pop

Spam

Y.B. (8/11/2016)

---

It's not a dynamic solution but something like this gets the output you want.

SELECT o.[Date], o.OrderID, x.ProdID, o.QTY, x.Category

FROM #Crosstab c

UNPIVOT (

Category FOR [Date] IN ([01/08], [02/08], [03/08], [04/08])

)...

This gave me the results you were looking for.

SELECT item, RType, FMonth, FYear, Qty,

SUM(QTy) OVER (PARTITION BY item ORDER BY FYear, FMonth) AS TotalQty

FROM TestData

WHERE RType = '2.Supply'

UNION...

It's not a dynamic solution but something like this gets the output you want.

SELECT o.[Date], o.OrderID, x.ProdID, o.QTY, x.Category

FROM #Crosstab c

UNPIVOT (

Category FOR [Date] IN ([01/08], [02/08], [03/08], [04/08])

) x

JOIN...